jonnyhoff/mcp-sqlite-manager
If you are the rightful owner of mcp-sqlite-manager and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
mcp-sqlite-manager is an MCP server built with FastMCP to interact with SQLite databases, allowing for easy querying, updating, and inspection of SQLite data using structured tools.
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 aSELECTquery and return results as JSON.write_query: ExecuteINSERT,UPDATE, orDELETEqueries.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 (likePRAGMA 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.
