MCP.so
ログイン

Mcp Server Sqlite

@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"
      ]
    }
  }
}

ツール

5

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.

FAQ from Mcp Server Sqlite

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.

コメント

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

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245