mcp-sqlite-manager
Provides tools for querying, updating, and managing SQLite databases, including executing SELECT, INSERT, UPDATE, DELETE, creating tables, listing tables, and describing table schemas.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-sqlite-managerShow me the users table schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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).
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.
This server cannot be deployed
Maintenance
Related MCP Connectors
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view detβ¦
- OleanderOAuthdev.oleander
The all-in-one data stack for agents. Upload files, run SQL, evolve tables, and render charts.
PDF, image, video, OCR, screenshot, SQL, QR and text tools for agents. No API key, no signup.
Read and edit DB Planner database schemas, diagrams and board layouts as an AI agent.
Related MCP Servers
- -licenseNot gradedqualityNot gradedmaintenanceEnables comprehensive SQLite database management through natural language, including database creation, table operations, data CRUD operations, backup/restore functionality, and CSV import/export capabilities.-
- AlicenseNot gradedqualityDmaintenanceEnables 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.23MIT
- FlicenseNot gradedqualityDmaintenanceEnables interaction with SQLite databases through natural language, supporting SQL queries, CSV imports, and schema exploration.9-
- AlicenseNot gradedqualityDmaintenanceEnables interaction with SQLite, MySQL, PostgreSQL, and SQL Server databases through tools for connection management, parameterized query execution, and schema inspection.41MIT