A
licenseNot graded
qualityA
maintenanceProvides safe, configurable SQL database access via MCP tools, enabling schema introspection, predefined queries, and structured updates with multi-backend support.
2
MIT
mcp-sqlite3
by daedalus
Provides tools for interacting with SQLite databases, including connection management, SQL execution, schema exploration, and CRUD operations.
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-sqlite3list all tables in the database"
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-sqlite3
MCP server exposing sqlite3 library functionality
Install
pip install mcp-sqlite3Related MCP server: MCP SQLite Server
Usage
from mcp_sqlite3 import mcp_server
mcp_server.run()CLI
mcp-sqlite3 --helpAPI
Exposes complete sqlite3 functionality as MCP tools.
Connection Tools
connect_database- Open a database connectionclose_connection- Close a database connectioncommit/rollback- Transaction control
SQL Execution Tools
execute_query- Execute a query and return resultsexecute_many- Execute with multiple parameter setsexecute_script- Execute a SQL script
Schema Tools
list_tables- List all tablesget_table_info- Get table schemacreate_table/drop_table- DDL operations
CRUD Tools
insert_row/update_rows/delete_rows/select_rows
Development
git clone https://github.com/daedalus/mcp-sqlite3.git
cd mcp-sqlite3
pip install -e ".[test]"
# run tests
pytest
# format
ruff format src/ tests/
# lint
ruff check src/ tests/
# type check
mypy src/MCP Server
mcp-name: io.github.daedalus/mcp-sqlite3
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
The Instant MCP server is a wrapper around the Instant Platform SDK that enables creating, managing, and updating InstantDB applications directly within an editor. It provides tools for fetching rules files for LLMs, retrieving and pushing app schemas, managing permission rules, and executing database queries. Key capabilities include schema management (get-schema, push-schema), permission management (get-perms, push-perms), query execution, and listing recent query history.
UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.
- dataOAuthco.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides comprehensive SQLite database interaction through MCP, enabling CRUD operations, custom SQL queries, and database exploration.501 npm127MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to manage and query SQLite databases through MCP tools, supporting CRUD operations, schema management, and saved views.4 npmMIT
- AlicenseNot gradedqualityDmaintenanceProvides a set of MCP tools to let AI assistants like Claude, Cursor, and VS Code Copilot interact with SQLite databases, supporting querying, schema management, and data import/export.10 npmMIT