SQLite MCP Server
Execute SQL queries, manage database schemas, and generate business insight memos.
Data last scanned 2 days ago · Reviewed 2 months ago
Overview
This server allows AI assistants to interact directly with SQLite databases, facilitating tasks ranging from schema exploration to data analysis. It provides tools for executing both read and write SQL operations, creating tables, and listing existing database structures.
Our verdict
This server carries a high security risk with a score of 0/100 and should be used with extreme caution. It is officially archived and no longer receives maintenance, meaning known or future vulnerabilities will not be patched. Furthermore, it lacks any authentication mechanism and enforces no read-only mode, granting any configured AI agent full, unrestricted write access to your database.
- Zero direct dependencies reduce potential supply-chain surface area.
- Native support for automated business insight memo generation.
- Archived repository indicates no further updates or bug fixes.
- Missing read-only mode permits unrestricted database modification.
- Lacks authentication, allowing anyone with config access to interact.
Tools
| Tool | Description | Risk |
|---|---|---|
| read_query | Execute SELECT queries to read data from the database | low |
| write_query | Execute INSERT, UPDATE, or DELETE queries | medium |
| create_table | Create new tables in the database | medium |
| list_tables | Get a list of all tables in the database | low |
| describe-table | View schema information for a specific table | low |
| append_insight | Add new business insights to the memo resource | medium |
Compatibility
| Client | Local | Docker | Remote | Read-only |
|---|---|---|---|---|
| Claude Desktop | ||||
| Cursor | ||||
| VS Code | ||||
| Windsurf | ||||
| ChatGPT |
Frequently asked questions
›What configuration is required to run the SQLite MCP server?
You must specify the database path using the --db-path argument when configuring the server in your environment.
›How are business insights managed in this server?
The server exposes a dynamic resource called memo://insights which automatically updates whenever you use the append_insight tool to record a new business finding.
›Can I use this server to modify database contents?
Yes, you can use the write_query tool to execute INSERT, UPDATE, or DELETE SQL statements.
›What is the purpose of the mcp-demo prompt?
The mcp-demo prompt guides you through database operations, helps generate schemas and sample data, and assists with the overall analysis and insight generation process.
›Is it possible to share the server configuration in VS Code?
Yes, you can define your server settings in a .vscode/mcp.json file within your workspace to facilitate sharing configurations with others.
Alternatives
Badge
Maintain this server? Add the live badge to your README.