Mcp Server Sqlite

Name: Mcp Server Sqlite
Author: ofershap

@ofershap

代码仓库

关于 Mcp Server Sqlite

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

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

ofershap

提交者

Ofer Shapira

配置

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

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

工具

Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table.

Get full schema: all tables with columns, types, and row counts.

Detailed info for a single table: columns, constraints, row count.

Run EXPLAIN QUERY PLAN to optimize queries.

List .db, .sqlite, .sqlite3 files 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.