mcp-sqlite-manager

mcp-sqlite-manager

3.3

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 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.