广告合作
MCP.so
登录

MCP Sqlite

@panasenco

代码仓库

基本信息

分类

数据库

许可证

Apache-2.0

传输方式

stdio

作者

panasenco

提交者

Aram Panasenco

关于 MCP Sqlite

MCP server for SQLite files. Supports Datasette-compatible metadata!

MCP Sqlite 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-sqlite",
        "/absolute/path/to/database.db",
        "--metadata",
        "/absolute/path/to/metadata.yml"
      ]
    }
  }
}

MCP Sqlite 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is mCP sqlite?

mcp-sqlite is an MCP server that provides AI agents with tools to explore and query SQLite databases without exposing external systems. It is compatible with Datasette, allowing both AI agents and humans to interact with the same local data.

How to use mcp-sqlite?

Install uv and then run uvx mcp-sqlite <sqlite_file> --metadata <metadata.yml> to start the server. You can use it with VS Code GitHub Copilot agent mode, MCP Inspector for interactive exploration, or Datasette for a human-friendly view.

Key features of mcp-sqlite

  • AI agents can retrieve the complete database catalog with sqlite_get_catalog().
  • Catalog can be enriched with descriptions using YAML or JSON metadata.
  • Canned queries from metadata become separate MCP tools (e.g., sqlite_execute_main_{tool name}).
  • Agents can execute arbitrary SQL with sqlite_execute().
  • Compatible with Datasette metadata for human exploration.

Use cases of mcp-sqlite

  • Provide AI agents contextual data from a local SQLite database.
  • Let agents explore table structures and run custom queries safely.
  • Combine AI‑driven database access with Datasette’s human interface.
  • Use interactive debugging with MCP Inspector during development.

常见问题

1

What tools does mcp-sqlite provide?

It provides `sqlite_get_catalog()` for the full table/column catalog (with optional metadata), `sqlite_execute()` for arbitrary SQL, and a separate MCP tool for each canned query defined in the metadata file.

2

How do I hide a table from the catalog?

Set `hidden: true` in the metadata YAML/JSON for that table. Note: the table remains accessible via `sqlite_execute()`, so hiding is not a security feature.

3

Can I use the same metadata file with Datasette?

Yes, mcp-sqlite’s metadata format is compatible with Datasette. You can run `uvx datasette serve <sqlite_file> --metadata <metadata.yml>` to view the same database.

4

What runtime dependencies are required?

You need [uv](https://docs.astral.sh/uv/getting-started/installation/) (a Python package manager) and a SQLite database file. No additional database server is required.

5

Are there any security considerations?

The `sqlite_execute()` tool allows arbitrary SQL, so any table (including hidden ones) can be queried. Do not rely on hidden tables as a security measure.

评论

数据库 分类下的更多 MCP 服务器

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

广告合作