daedalus avatar

Mcp Sqlite3

daedalus/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 tools

Public 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

PyPI Python Ruff

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 connection
  • close_connection - Close a database connection
  • commit / rollback - Transaction control

SQL Execution Tools

  • execute_query - Execute a query and return results
  • execute_many - Execute with multiple parameter sets
  • execute_script - Execute a SQL script

Schema Tools

  • list_tables - List all tables
  • get_table_info - Get table schema
  • create_table / drop_table - DDL operations

View the full README on GitHub

Details

Repository
github.com/daedalus/mcp-sqlite3
Package
mcp-sqlite3
Transport
STDIO
Registry
MCP registry, active

More from daedalus