Skip to main content
Glama
jonnyhoff

mcp-sqlite-manager

by jonnyhoff

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


Related MCP server: SQLite MCP Server

πŸ“¦ 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.

Maintenance

ActivityInactive
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers

  • -
    license
    Not graded
    quality
    Not graded
    maintenance
    Enables comprehensive SQLite database management through natural language, including database creation, table operations, data CRUD operations, backup/restore functionality, and CSV import/export capabilities.
    -
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables LLM agents to perform complete database operations on SQLite databases, including creating tables, executing queries, and managing data through CRUD operations with schema inspection capabilities.
    23
    MIT
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables interaction with SQLite, MySQL, PostgreSQL, and SQL Server databases through tools for connection management, parameterized query execution, and schema inspection.
    4
    1
    MIT