MCP Server Sqlite

@ofershap

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

ofershap

投稿者

Ofer Shapira

MCP Server Sqlite について

MCP server for SQLite — query databases, inspect schemas, explain queries

MCP Server Sqlite の設定

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

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite-server"
      ]
    }
  }
}

MCP Server Sqlite のツール

Execute a SQL query against a SQLite database. Returns results as a formatted table. Read-only by default.

Get the schema of a SQLite database: all tables with columns and row counts.

Get detailed info about a single table: columns, types, constraints, and row count.

Explain the query plan for a SQL query (EXPLAIN QUERY PLAN). Helps optimize queries.

List all SQLite database files (.db, .sqlite, .sqlite3) in a directory.

概要

What is Mcp Server Sqlite?

Mcp Server Sqlite is a TypeScript Model Context Protocol server that lets AI assistants query SQLite databases, inspect schemas, and explain queries. It is read-only by default for safety and works with any MCP client (Claude Desktop, Cursor, VS Code Copilot, etc.) by reading local .db files with no authentication required.

How to use Mcp Server Sqlite?

Run npx mcp-sqlite-server to start the server, then configure it in your MCP client by adding a server entry with command "npx" and arguments ["mcp-sqlite-server"]. No additional installation steps are needed.

Key features of Mcp Server Sqlite

Execute SQL queries (SELECT, PRAGMA, EXPLAIN, WITH) via the query tool.
Retrieve full schema with tables, columns, types, and row counts via schema.
Get detailed table info including constraints and row counts via table_info.
Run EXPLAIN QUERY PLAN to optimize queries via explain.
List .db, .sqlite, and .sqlite3 files in a directory via list_databases.
Read-only by default; optional write mode via readonly=false.

Use cases of Mcp Server Sqlite

Explore database schema and contents directly from an AI assistant.
Run SQL queries on local SQLite databases during development without switching tools.
Analyze and optimize query performance using EXPLAIN QUERY PLAN.
Discover all SQLite files in a project directory.

よくある質問

What is the default safety mode?

Read-only by default. The `query` tool only accepts SELECT, PRAGMA, EXPLAIN, and WITH statements in readonly mode.

How does it differ from the official MCP SQLite server?

The official reference is Python-only. This server is built with TypeScript/Node.js, making it a natural fit for TypeScript and Node.js environments.

What runtime is required?

Node.js and npm (npx) are required to run the `npx mcp-sqlite-server` command.

What authentication or transport does it use?

No authentication is needed. It reads local `.db` files and uses the standard stdio transport for MCP.

Can I enable write operations?

Yes. Set `readonly=false` in the tool arguments to allow INSERT, UPDATE, DELETE, and other write statements.

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

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

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

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397