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.
MCP SQLite Server
@jparkerweb
基本情報
MCP SQLite Server について
🐇 Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities
MCP SQLite Server の設定
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"MCP SQLite Server": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}
}MCP SQLite Server のツール
8Get 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
よくある質問
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 Server for MySQL based on NodeJS
benborlaA 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
golfdata.online - Verified Golf Clubs
golfdata.onlineVerified 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
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
617
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
コメント