mcp-sqlite-manager
About
An MCP server to interact with SQLite databases
Details
- Author
- jonnyhoff
- Downloads
- 315
- Categories
- Database
Jump to
- read_query: Execute SELECT queries and return JSON results
- write_query: Run INSERT, UPDATE, or DELETE statements
- create_table: Create new tables from SQL schema definitions
- list_tables: List all tables in the connected database
- describe_table: Show schema info via PRAGMA table_info
Install the package globally using pipx (pipx install --force mcp-sqlite-manager), then configure it as an MCP tool in Cursor by adding the command mcp-sqlite-manager to ~/.cursor/mcp.json. Once connected, you can call its five tools: read_query, write_query, create_table, list_tables, and describe_table.
mcp-sqlite-manager
An MCP server built with FastMCP to interact with SQLite databases. Easily query, update, and inspect SQLite data using structured tools.
---
🚀 Features
- read_query: Execute a SELECT query and return results as JSON.
- write_query: Execute INSERT, UPDATE, or DELETE queries.
- create_table: Create new tables using SQL schema definitions.
- list_tables: Return a list of all tables in the database.
- describe_table: Show schema info for a specific table (like PRAGMA table_info).
---
📦 Installation
🐍 With pipx
This package is designed to be installed with pipx, which allows you to run Python applications in isolated environments.
pipx install --force mcp-sqlite-manager
🔌 MCP Integration in Cursor
To use this server as an MCP tool within Cursor, add the following configuration to your ~/.cursor/mcp.json file or configure via the settings menu in Cursor.
{
"mcpServers": {
"mcp-sqlite-manager": {
"command": "mcp-sqlite-manager"
}
}
}
🧑💻 Author
Jonathan Hoffman
GitHub
LinkedIn
🐍 Python, Django, JS, Web, ML, AI, coffee and 🍺 beer.
---
📄 License
MIT – free to use, hack, and improve.Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
