MCP SQLite
panasenco/mcp-sqlite
Acesso seguro a dados SQLite para agentes IA com metadados enriquecidos
Ver no GitHubServidor MCP que expõe bancos de dados SQLite como ferramentas para agentes de IA, com suporte a metadados compatíveis com Datasette. Permite que agentes consultem estruturas de tabelas, executem queries SQL arbitrárias e acessem consultas pré-configuradas sem expor sistemas externos.
Instalação
npx convez-ai panasenco/mcp-sqlite1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.
Métricas
Casos de uso
- Fornecer dados estruturados a agentes IA mantendo isolamento do sistema
- Exploração interativa de bancos de dados com MCP Inspector e Datasette
- Criar consultas pré-configuradas (canned queries) para padrões de uso comum
Veredito

Ferramenta sólida e bem-pensada para expor dados SQLite a agentes IA com segurança. A compatibilidade com Datasette agrega valor ao permitir exploração humana nos mesmos arquivos, reduzindo duplicação de configuração.
README
A tradução para o português deste README ainda está na fila.
mcp-sqlite
Provide useful data to AI agents without giving them access to external systems. Compatible with Datasette for human users!
Features
- AI agents can get the structure of all tables and columns in the SQLite database in one command -
sqlite_get_catalog.- The catalog can be enriched with descriptions for the tables and columns using a simple YAML or JSON metadata file.
- The same metadata file can contain canned queries to the AI to use.
Each canned query will be turned into a separate MCP tool
sqlite_execute_main_{tool name}. - AI agents can execute arbitrary SQL queries with
sqlite_execute.
Quickstart using Visual Studio Code
-
Install uv.
-
Install Visual Studio Code if you don't already have it. Turn on GitHub Copilot.
-
Open this repo in VS Code. Open a GitHub Copilot agent mode chat. Check the available tools - you should see MCP Server: sqlite_sample with three available tools.

-
You should be able to ask Copilot in agent mode a question like "Get Titanic survivors of age 28" and get a response.

-
Use the sample MCP configuration file mcp.json and the sample metadata file titanic.yml as a starting point for your own configuration.
Interactive exploration with MCP Inspector and Datasette
The same database and metadata files can be used to explore the data interactively with MCP Inspector and Datasette.
| MCP Inspector | Datasette |
|---|---|
![]() | ![]() |
![]() | ![]() |
MCP Inspector
Use the MCP Inspector dashboard to interact with the SQLite database the same way that an AI agent would:
- Install npm.
- Run:
npx @modelcontextprotocol/inspector uvx mcp-sqlite sample/titanic.db --metadata sample/titanic.yml
Datasette
Since mcp-sqlite metadata is compatible with the Datasette metadata file, you can also explore your data with Datasette:
uvx datasette serve sample/titanic.db --metadata sample/titanic.yml
Compatibility with Datasette allows both AI agents and humans to easily explore the same local data!
MCP Tools provided by mcp-sqlite
- sqlite_get_catalog(): Tool the agent can call to get the complete catalog of the databases, tables, and columns in the data, combined with metadata from the metadata file.
In an earlier iteration of
mcp-sqlite, this was a resource instead of a tool, but resources are not as widely supported, so it got turned into a tool. If you have a usecase for the catalog as a resource, open an issue and we'll bring it back! - sqlite_execute(sql): Tool the agent can call to execute arbitrary SQL. The table results are returned as HTML. For more information about why HTML is the best format for LLMs to process, see Siu et al.
- {canned query name}({canned query args}): A tool is created for each canned query in the metadata, allowing the agent to run predefined queries without writing any SQL.
Usage
Command-line options
usage: mcp-sqlite [-h] [-m METADATA] [-p PREFIX] [-v] sqlite_file
CLI command to start an MCP server for interacting with SQLite data.
positional arguments:
sqlite_file Path to SQLite file to serve the MCP server for.
options:
-h, --help show this help message and exit
-m, --metadata METADATA
Path to Datasette-compatible metadata YAML or JSON file.
-p, --prefix PREFIX Prefix for MCP tools. Defaults to no prefix.
-v, --verbose Be verbose. Include once for INFO output, twice for DEBUG output.
Metadata
Hidden tables
Hiding a table with hidden: true will hide it from the catalog returned by the MCP tool sqlite_get_catalog().
However, note that the table will still be accessible by the AI agent!
Never rely on hiding a table from the catalog as a security feature.
Canned queries
Canned queries are each turned into a separate callable MCP tool by mcp-sqlite.
For example, a query named my_canned_query will become a tool my_canned_query.
The canned queries functionality is still in active development with more features planned for development soon:
Roadmap
| Datasette query feature | Supported in mcp-sqlite? |
|---|---|
| Displayed in catalog | ✅ |
| Executable | ✅ |
| Titles | ✅ |
| Descriptions | ✅ |
| Parameters | ✅ |
| Explicit parameters | ❌ (planned) |
| Hide SQL | ✅ |
| Write restrictions on canned queries | ✅ |
| Pagination | ❌ (planned) |
| Cross-database queries | ❌ (planned) |
| Fragments | ❌ (not planned) |
| Magic parameters | ❌ (not planned) |



