Provides tools for executing SQL queries (SELECT, INSERT, UPDATE, DELETE), inspecting schema, listing tables, and managing transactions on a SQLite database.
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 Show me the schema for the users table"
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 server that provides SQLite database operations. Allows AI assistants to query, modify and manage SQLite databases through the Model Context Protocol.
pip install -r requirements.txtRelated MCP server: mcp-server-sqlite
from mcpsqlite import SQLiteServer
server = SQLiteServer(db_path="data.db")
server.run()Execute SELECT, INSERT, UPDATE, DELETE queries
Schema inspection and table listing
Transaction support with rollback
Query result formatting
Safe parameterized queries
Execute a SQL query and return results.
{
"name": "query",
"arguments": {
"sql": "SELECT * FROM users WHERE age > ?",
"params": [18]
}
}Execute a SQL statement (INSERT, UPDATE, DELETE).
{
"name": "execute",
"arguments": {
"sql": "INSERT INTO users (name, age) VALUES (?, ?)",
"params": ["Alice", 25]
}
}Get database schema information.
{
"name": "schema",
"arguments": {
"table": "users"
}
}List all tables in the database.
{
"name": "tables",
"arguments": {}
}server = SQLiteServer(
db_path="data.db",
read_only=False,
max_rows=1000
)python -m mcpsqlite --db data.db --port 8080{
"mcpServers": {
"sqlite": {
"command": "python",
"args": ["-m", "mcpsqlite", "--db", "data.db"]
}
}
}MIT
This server cannot be deployed
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
MCP server for AI dialogue using various LLM models via AceDataCloud
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
GibsonAI MCP server: manage your databases with natural language
