Share:
About
Query and modify a local SQLite database file. Inspect tables and schemas, run SELECT/INSERT/UPDATE/DELETE, and get results back as structured rows. Ideal for prototyping, local caches, and small analytics workloads where a full Postgres install is overkill.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about SQLite MCP.
- What is the primary function of the SQLite MCP?
- The SQLite MCP allows users to execute SQL queries and modifications directly against a local SQLite database file. It supports typical operations like SELECT, INSERT, UPDATE, and DELETE, returning results as structured rows.
- How can I install the SQLite MCP in an MCP client like Claude Desktop?
- Installation typically involves adding the SQLite MCP to your client's server directory. You would likely specify 'stdio' as the transport and configure any necessary local file paths for your SQLite database.
- Does the SQLite MCP require any authentication or API keys?
- No, the SQLite MCP does not require API keys, OAuth, or any other authentication credentials. It operates locally with directly specified database files.
- What are the common use cases for the SQLite MCP?
- This MCP is ideal for rapid prototyping, managing local data caches, and small-scale analytical tasks. It is particularly useful when a full-fledged database system like PostgreSQL would be an excessive overhead.
- Are there any limitations or prerequisites for using the SQLite MCP?
- A key limitation is that it's designed for local, file-based SQLite databases, making it unsuitable for networked or distributed database scenarios. You must also provide a valid SQLite database file.
Install SQLite MCP
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"sqlite": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sqlite"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"sqlite": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sqlite"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"sqlite": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-sqlite"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.