Summary
This server has been deprecated in favor of db-mcp, a TypeScript rewrite that expands the tool count from 73 to 125+ and supports modern MCP protocols. The original Python version provided SQLite operations for JSONB manipulation, full-text search, geospatial queries, and analytics over stdio transport. If you're looking for SQLite connectivity, grab the new version via npx @anthropic-ai/db-mcp instead. It adds SSE and HTTP transports alongside stdio, ships with updated MCP SDK support, and is actively maintained. The archived version here stops at v2.6.5 with no further updates planned.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Tools
Public tool metadata for what this MCP can expose to an agent.
15 tools
sqlite_queryExecute a SELECT query on the SQLite database and return rows as a JSON array. Use this for reading data — supports any valid SELECT statement with optional parameter binding for safe queries.2 params
Execute a SELECT query on the SQLite database and return rows as a JSON array. Use this for reading data — supports any valid SELECT statement with optional parameter binding for safe queries.
Parameters* required
paramsarrayArray of bind parameter values for ? placeholders (e.g., [25])
sqlstringSQL SELECT query to execute (e.g., "SELECT * FROM users WHERE age > ?")
sqlite_executeExecute a write statement (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) on the SQLite database. Returns the number of rows changed and the last inserted row ID. Use parameter binding for safe writes.2 params
Execute a write statement (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) on the SQLite database. Returns the number of rows changed and the last inserted row ID. Use parameter binding for safe writes.
Parameters* required
paramsarrayArray of bind parameter values for ? placeholders (e.g., ["Alice", 30])
sqlstringSQL write statement to execute (e.g., "INSERT INTO users (name, age) VALUES (?, ?)")
sqlite_run_scriptExecute multiple SQL statements in a single transaction. All statements succeed or all fail (atomic). Separate statements with semicolons. Use for migrations, seed data, or batch operations.1 params
Execute multiple SQL statements in a single transaction. All statements succeed or all fail (atomic). Separate statements with semicolons. Use for migrations, seed data, or batch operations.
Parameters* required
sqlstringMultiple SQL statements separated by semicolons (e.g., "CREATE TABLE t1 (id INTEGER); INSERT INTO t1 VALUES (1);")
sqlite_list_tablesList all tables and views in the database with their row counts. Use this as the first step to explore an unfamiliar database. Returns table name, type (table or view), and row count.1 params
List all tables and views in the database with their row counts. Use this as the first step to explore an unfamiliar database. Returns table name, type (table or view), and row count.
Parameters* required
_fieldsstringComma-separated list of fields to return (e.g., "name,type,rowCount"). Leave empty for all fields.
sqlite_describe_tableGet the column schema of a table — column names, data types, NOT NULL constraints, default values, and primary key flags. Also returns the CREATE TABLE SQL statement.1 params
Get the column schema of a table — column names, data types, NOT NULL constraints, default values, and primary key flags. Also returns the CREATE TABLE SQL statement.
Parameters* required
tablestringTable name to describe (e.g., "users")
sqlite_list_indexesList all indexes on a table — index name, uniqueness, origin (manual or auto-created), and whether it is a partial index.1 params
List all indexes on a table — index name, uniqueness, origin (manual or auto-created), and whether it is a partial index.
Parameters* required
tablestringTable name to list indexes for (e.g., "users")
sqlite_list_foreign_keysList foreign key constraints on a table — referenced table, local and remote columns, ON UPDATE and ON DELETE actions.1 params
List foreign key constraints on a table — referenced table, local and remote columns, ON UPDATE and ON DELETE actions.
Parameters* required
tablestringTable name to list foreign keys for (e.g., "orders")
sqlite_create_tableCreate a new table with column definitions. Each column has a name, type, and optional constraints (PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT). Use ifNotExists to skip if the table already exists.3 params
Create a new table with column definitions. Each column has a name, type, and optional constraints (PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT). Use ifNotExists to skip if the table already exists.
Parameters* required
columnsarrayArray of column definitions with name, type, and optional constraints
ifNotExistsbooleanSkip creation if table already exists (default: false)
tablestringName for the new table (e.g., "users")
sqlite_alter_tableAlter an existing table — add a new column, rename a column, or rename the table. SQLite does not support dropping columns via ALTER TABLE.9 params
Alter an existing table — add a new column, rename a column, or rename the table. SQLite does not support dropping columns via ALTER TABLE.
Parameters* required
actionstringAlter action: "add_column" to add a new column, "rename_column" to rename a column, "rename_table" to rename the tableone of
add_column · rename_column · rename_tablecolumnstringNew column name (for add_column action)
defaultvalueDefault value for new column (for add_column)
newNamestringNew column name (for rename_column action)
newTableNamestringNew table name (for rename_table action)
notNullbooleanAdd NOT NULL constraint to new column (for add_column, default: false)
oldNamestringCurrent column name to rename (for rename_column action)
tablestringCurrent table name to alter (e.g., "users")
typestringColumn data type (for add_column action, e.g., "TEXT", "INTEGER")
sqlite_drop_tableDrop (delete) a table and all its data permanently. This action is irreversible. Use ifExists to avoid errors if the table does not exist.2 params
Drop (delete) a table and all its data permanently. This action is irreversible. Use ifExists to avoid errors if the table does not exist.
Parameters* required
ifExistsbooleanSkip if table does not exist instead of throwing error (default: false)
tablestringTable name to drop (e.g., "old_users")
sqlite_create_indexCreate an index on one or more columns to speed up queries. Optionally create a UNIQUE index to enforce uniqueness. Index name is auto-generated if not provided.5 params
Create an index on one or more columns to speed up queries. Optionally create a UNIQUE index to enforce uniqueness. Index name is auto-generated if not provided.
Parameters* required
columnsarrayArray of column names to index (e.g., ["email"] or ["last_name", "first_name"])
ifNotExistsbooleanSkip if index already exists (default: false)
indexNamestringCustom index name (auto-generated as idx_table_col1_col2 if omitted)
tablestringTable to create the index on (e.g., "users")
uniquebooleanCreate a UNIQUE index to enforce uniqueness (default: false)
sqlite_drop_indexDrop (delete) an index by name. Does not affect the table data, only removes the index. Use ifExists to avoid errors if the index does not exist.2 params
Drop (delete) an index by name. Does not affect the table data, only removes the index. Use ifExists to avoid errors if the index does not exist.
Parameters* required
ifExistsbooleanSkip if index does not exist instead of throwing error (default: false)
indexNamestringName of the index to drop (e.g., "idx_users_email")
sqlite_get_infoGet database metadata — file path, file size, table count, page count, page size, journal mode, WAL status, encoding, and SQLite version. Use this to understand the database state.1 params
Get database metadata — file path, file size, table count, page count, page size, journal mode, WAL status, encoding, and SQLite version. Use this to understand the database state.
Parameters* required
_fieldsstringComma-separated list of fields to return (e.g., "path,size,tables"). Leave empty for all fields.
sqlite_vacuumOptimize and compact the database file by rebuilding it. Reclaims space from deleted rows and defragments the file. Returns file size before and after. May take time on large databases.1 params
Optimize and compact the database file by rebuilding it. Reclaims space from deleted rows and defragments the file. Returns file size before and after. May take time on large databases.
Parameters* required
_fieldsstringComma-separated list of fields to return (e.g., "sizeBefore,sizeAfter"). Leave empty for all fields.
sqlite_integrity_checkRun PRAGMA integrity_check to verify the database is not corrupted. Returns "ok" if the database is healthy, or a list of issues found. Use after crashes or suspicious behavior.1 params
Run PRAGMA integrity_check to verify the database is not corrupted. Returns "ok" if the database is healthy, or a list of issues found. Use after crashes or suspicious behavior.
Parameters* required
_fieldsstringComma-separated list of fields to return (e.g., "ok,errors"). Leave empty for all fields.
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Registryactive
Packagesqlite-mcp-server-enhanced
TransportSTDIO
UpdatedOct 13, 2025
