MCP SQLite Server

@jparkerweb

代码仓库主页

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

jparkerweb

关于 MCP SQLite Server

🐇 Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities

#nodejs #development #database #sqlite #mcp #cursor #windsurf#aitooling

MCP SQLite Server 配置

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

{
  "mcpServers": {
    "MCP SQLite Server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite",
        "<path-to-your-sqlite-database.db>"
      ]
    }
  }
}

MCP SQLite Server 工具

Get information about the SQLite database including path, existence, size, and table count

Execute a raw SQL query against the database with optional parameter values

List all user tables in the SQLite database (excludes system tables)

Get the schema information for a specific table including column details

Insert a new record into a table with specified data

Read records from a table with optional conditions, limit, and offset

Update records in a table based on specified conditions

Delete records from a table based on specified conditions

概览

What is 🐇 MCP SQLite Server?

The 🐇 MCP SQLite Server is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities. It is designed for developers using MCP-compatible IDEs (e.g., Cursor, VSCode) who need to perform CRUD operations, explore schemas, and execute custom SQL queries against a local SQLite database.

How to use 🐇 MCP SQLite Server?

Define the command in your IDE’s MCP Server settings using npx -y mcp-sqlite <path-to-your-sqlite-database.db>. For example, in Cursor add a JSON entry under mcpServers; in VSCode use "servers" with type "stdio". The database path must be provided as a command argument.

Key features of 🐇 MCP SQLite Server

Complete CRUD operations (Create, Read, Update, Delete)
Database exploration and schema introspection
Execute custom parameterized SQL queries
Retrieve database metadata with db_info
List all tables with list_tables
Get detailed table schema with get_table_schema

Use cases of 🐇 MCP SQLite Server

Exploring the structure and schema of a SQLite database
Inserting, reading, updating, or deleting records with optional filtering
Running ad‑hoc SQL queries with parameter binding
Inspecting database metadata and table lists directly from an MCP client

常见问题

What is the 🐇 MCP SQLite Server?

It is an MCP server that provides SQLite database interaction capabilities, enabling CRUD operations, schema exploration, and custom SQL execution within MCP‑compatible clients.

How do I install and configure it?

Install and run it via `npx -y mcp-sqlite <path-to-your-sqlite-database.db>`. Configure the command in your IDE’s MCP Server settings (e.g., Cursor or VSCode).

What tools are available?

The server exposes tools for database info (`db_info`), listing tables (`list_tables`), schema retrieval (`get_table_schema`), CRUD operations (`create_record`, `read_records`, `update_records`, `delete_records`), and custom queries (`query`).

What dependencies does it require?

It is built with the Model Context Protocol SDK and the `node-sqlite3` library.

Where does the database data live?

The data resides in a SQLite database file whose path you provide as an argument when launching the server.

数据库分类下的更多 MCP 服务器

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Elasticsearch MCP Server

elastic

685

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K