広告掲載
MCP.so
ログイン

Sqlite Reader MCP Server

@abhinavnatarajan

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

abhinavnatarajan

Sqlite Reader MCP Server について

MCP server for reading SQLite databases

#sqlite#database#mcp#read-only

Sqlite Reader MCP Server の設定

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

{
  "mcpServers": {
    "sqlite-reader-mcp": {
      "command": "uv",
      "args": [
        "tool",
        "install",
        "git+https://github.com/abhinavnatarajan/sqlite-reader-mcp"
      ]
    }
  }
}

Sqlite Reader MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

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

概要

What is sqlite-reader-mcp?

sqlite-reader-mcp is a lightweight MCP server that provides read-only access to SQLite databases. It allows users to execute SELECT queries, list tables, and describe table schemas. Aimed at developers and AI agents who need safe, programmatic exploration of SQLite databases through the Model Context Protocol.

How to use sqlite-reader-mcp?

Install with uv tool install git+https://github.com/abhinavnatarajan/sqlite-reader-mcp. Then start the server using sqlite-reader-mcp --paths /path/to/database.db /path/to/allowed_directory. Once running, interact via any FastMCP client using the built-in tools: read_query, list_tables, and describe_table.

Key features of sqlite-reader-mcp

  • Read-only access – no data modification allowed
  • Secure path whitelisting for approved database files
  • SQL validation permits only SELECT and WITH statements
  • Asynchronous operations with aiosqlite
  • Automatic row limiting (default 1000 rows)
  • Three MCP tools: read_query, list_tables, describe_table

Use cases of sqlite-reader-mcp

  • Safely explore SQLite databases through an MCP interface
  • Audit database schema and table structures
  • Run read-only analytical queries from an AI agent
  • Integrate SQLite data retrieval into LLM-driven workflows
  • Provide controlled database access without write risk

よくある質問

1

What tools does sqlite-reader-mcp provide?

It provides three tools: `read_query` to execute SELECT queries, `list_tables` to list all tables in a database, and `describe_table` to get column schema information for a specific table.

2

How does the server enforce read-only security?

The server enforces read-only by rejecting any SQL that is not a SELECT or WITH statement. It also restricts database access to absolute file paths explicitly passed via the `--paths` argument, and validates that paths exist.

3

What are the runtime requirements?

Python 3.13 or later, plus the packages `aiosqlite >= 0.21.0`, `fastmcp >= 2.6.1`, and `sqlparse >= 0.5.3`.

4

How do I specify which databases the server can access?

Use the `--paths` (or `-p`) command-line argument with one or more absolute paths to SQLite database files or directories containing them. All paths must exist and be absolute.

5

Can I execute multiple SQL statements in one query?

No. The server rejects query strings containing multiple statements to prevent injection or unintended operations. Trailing semicolons are automatically removed.

コメント

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

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

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

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

広告掲載