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
MCP server for AI dialogue using various LLM models via AceDataCloud
GibsonAI MCP server: manage your databases with natural language
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
