
Mcp Sqlite3
This server wraps Python's sqlite3 library and exposes it through MCP tools. You get connection management (connect, close, commit, rollback), direct SQL execution (execute_query, execute_many, execute_script), schema inspection (list_tables, get_table_info), and convenience CRUD operations for common database tasks. Reach for this when you want Claude to interact with SQLite databases without writing custom integration code. It handles the full lifecycle from opening connections to running queries to managing transactions. The tool set is comprehensive enough for both quick data queries and more complex database operations.
- GitHub stars
- 1
- tools
- 15
- transport
- STDIO
- last updated
- Mar 31, 2026
Tools
15 toolsPublic tool metadata for what this MCP can expose to an agent.
connect_databaseOpen a database connection
Open a database connection
No parameter schema in public metadata yet.
close_connectionClose a database connection
Close a database connection
No parameter schema in public metadata yet.
commitTransaction control
Transaction control
No parameter schema in public metadata yet.
rollbackTransaction control
Transaction control
No parameter schema in public metadata yet.
execute_queryExecute a query and return results
Execute a query and return results
No parameter schema in public metadata yet.
execute_manyExecute with multiple parameter sets
Execute with multiple parameter sets
No parameter schema in public metadata yet.
execute_scriptExecute a SQL script
Execute a SQL script
No parameter schema in public metadata yet.
list_tablesList all tables
List all tables
No parameter schema in public metadata yet.
get_table_infoGet table schema
Get table schema
No parameter schema in public metadata yet.
create_tableDDL operations
DDL operations
No parameter schema in public metadata yet.
drop_tableDDL operations
DDL operations
No parameter schema in public metadata yet.
insert_row
No parameter schema in public metadata yet.
update_rows
No parameter schema in public metadata yet.
delete_rows
No parameter schema in public metadata yet.
select_rows
No parameter schema in public metadata yet.
Sponsors
Readme
mcp-sqlite3
MCP server exposing sqlite3 library functionality
Install
pip install mcp-sqlite3
Usage
from mcp_sqlite3 import mcp_server
mcp_server.run()
CLI
mcp-sqlite3 --help
API
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
Details
- Repository
- github.com/daedalus/mcp-sqlite3
- Package
mcp-sqlite3- Transport
- STDIO
- Registry
- MCP registry, active