Skip to main content
Glama
mcp-sqlite-manager

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.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      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.
      MIT
    • 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.
      26 npm
      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 npm
      1
      MIT