SQLite MCP Server
@jacksteamdev
关于 SQLite MCP Server
暂无概览
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mcp-sqlite-bun-server": {
"command": "bun",
"args": [
"run",
"setup"
]
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is SQLite MCP Server?
A Model Context Protocol (MCP) server that provides database interaction and business intelligence capabilities through SQLite. It enables running SQL queries, analyzing business data, and automatically generating business insight memos.
How to use SQLite MCP Server?
Install Bun, clone the repository, run bun install to install dependencies, then bun run setup to automatically configure the server in Claude Desktop (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json). The server exposes tools, a dynamic resource, and a demo prompt for database operations.
Key features of SQLite MCP Server
- Execute SELECT, INSERT, UPDATE, DELETE queries
- Create tables with CREATE TABLE statements
- List and describe database tables
- Append business insights to a dynamic memo
- Auto-updating insights memo resource (
memo://insights) - Demonstration prompt for guided database analysis
Use cases of SQLite MCP Server
- Run ad‑hoc SQL queries against a local SQLite database
- Analyze business data and store discovered insights
- Automatically generate and maintain a business insights memo
- Walk through database analysis with a guided demo prompt
FAQ from SQLite MCP Server
What runtime does SQLite MCP Server require?
It requires Bun to be installed on your system.
Where is the SQLite database file stored?
The database file is created as data.sqlite in the project root directory; it is created automatically if it doesn’t exist.
How do I configure SQLite MCP Server for Claude Desktop?
Run bun run setup to automatically add the server configuration to your Claude Desktop config file (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json).
What logs does the server keep?
The server writes detailed logs to server.log in the project root directory, including timestamps, log levels (DEBUG, INFO, WARN, ERROR, FATAL), and structured metadata.
What tools are provided?
Six core tools: read-query, write-query, create-table, list-tables, describe-table, and append-insight.
数据库 分类下的更多 MCP 服务器
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
MCP Server for Milvus
zilliztechModel Context Protocol Servers for Milvus
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
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.
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
评论