Summary
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.
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →
Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →
Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →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
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
Featured
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →