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.

よくある質問

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.

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.

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.

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.

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.

「データベース」の他のコンテンツ

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

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note