mcp-sqlite

Name: mcp-sqlite
Author: panasenco

@panasenco

リポジトリ

mcp-sqlite について

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

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0

ランタイム

python

トランスポート

stdio

公開者

panasenco

投稿者

Aram Panasenco

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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.

FAQ from mcp-sqlite

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 (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.