Sqlite3 MCP server
MCP server exposing sqlite3 library functionality
1 stars25 downloads/wk
Reviews
Write oneNobody has reviewed Sqlite3 yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Sqlite3 tools (37, 11 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
alter_table_add_columnAdd a column to a table.
backup_databaseBackup the database to a file.
close_connectionClose a database connection.
commitCommit any pending transaction to the database.
complete_sql_statementCheck if a SQL statement is syntactically complete.
connect_databaseOpen a database connection.
create_python_aggregatewrite actionRegister a Python class as a SQLite aggregate function.
create_python_functionwrite actionRegister a Python function as a SQLite function.
create_tablewrite actionCreate a new table.
delete_rowswrite actionDelete rows from a table.
deserialize_databaseDeserialize a base64-encoded database.
drop_functionwrite actionDrop a user-defined function.
drop_tablewrite actionDrop a table.
execute_manywrite actionExecute a SQL statement with multiple parameter sets.
execute_querywrite actionExecute a SQL query and return results.
execute_scriptwrite actionExecute a SQL script with multiple statements.
export_sql_dumpExport the database as a SQL dump.
fetch_resultsFetch results from a cursor.
get_columnsGet column information for a table.
get_foreign_keysGet foreign key information for a table.
get_indexesGet index information for a table or all indexes.
get_primary_keysGet primary key columns for a table.
get_sqlite3_versionGet the sqlite3 module version.
get_sqlite_versionGet the SQLite library version.
get_table_infoGet detailed information about a table.
get_table_sqlGet the CREATE TABLE SQL statement for a table.
insert_rowwrite actionInsert a row into a table.
list_tablesList all tables in the database.
register_adapterRegister an adapter for a Python type to SQL type.
register_converterRegister a converter for a SQL type to Python type.
rename_tableRename a table.
restore_databaseRestore the database from a backup file.
rollbackRollback any pending transaction.
select_rowsSelect rows from a table.
serialize_databaseSerialize a database to base64-encoded bytes.
update_rowswrite actionUpdate rows in a table.
vacuumVacuum the database to reclaim space and optimize.
Public scan report
scanner v0.1.9 · 2026-09-27 · same rubric, same numbers if you re-run it
- Code scan4 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitylocal package, no credentials required12/15
- Maintenancelast push 159 days ago8/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
How Sqlite3 compares
Against every graded MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 82/100
- higher than 63% of 48,273 servers
- Tools
- 37
- the typical server has 7
- Tools that change things
- 30%
- typical: 0%. Fewer write tools means less an agent can break
- GitHub stars
- 1
- more than 65% of 28,534 servers
- Downloads a week
- 25
- more than 13% of 11,915 servers with a package
What its tools let an agent do: 22 read · 6 create · 3 change · 3 delete · 3 run or deploy
Install Sqlite3 in Claude Code, Cursor or VS Code
claude mcp add mcp-sqlite3 -- uvx mcp-sqlite3
What the publisher says
From the Sqlite3 repository's README, as published. We do not edit it. Read it on GitHub
mcp-sqlite3
MCP server exposing sqlite3 library functionality
Install
pip install mcp-sqlite3Usage
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 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
- gettableinfo - Get table schema
- createtable / droptable - DDL operations
CRUD Tools
- insertrow / updaterows / deleterows / selectrows
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
Nothing above is checked by us. What we check is on the safety report.
Sqlite3: common questions
- Is Sqlite3 MCP server safe?
- Mostly: it is graded B (82/100). Read the Sqlite3 safety report
- How do I install Sqlite3?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does Sqlite3 need an API key?
- Not as far as the registry entry and our scan can tell: no credentials are declared or required.
- Is Sqlite3 maintained?
- The last commit was 195 days ago (2026-04-21). The latest release is v0.1.3.
- How does Sqlite3 compare with other MCP servers?
- safety score 82/100 (higher than 63% of 48,273 servers); tools 37 (the typical server has 7); tools that change things 30% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.