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.
- dataOAuthco.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
PDF, image, video, OCR, screenshot, SQL, QR and text tools for agents. No API key, no signup.
Related MCP Servers
- AlicenseNot 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.MIT
- 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.21 npmMIT
- FlicenseNot gradedqualityDmaintenanceEnables interaction with SQLite databases through natural language, supporting SQL queries, CSV imports, and schema exploration.3 npm-
- AlicenseNot gradedqualityDmaintenanceEnables interaction with SQLite, MySQL, PostgreSQL, and SQL Server databases through tools for connection management, parameterized query execution, and schema inspection.4 npm1MIT