db-mcp

Get information about the db-mcp server and registered adapters

Check health status of all database connections

List all registered database adapters

Create a backup of the database to a file.

Analyze table statistics to improve query performance.

Check database integrity for corruption or errors.

Optimize database by reindexing and/or analyzing.

Execute a SELECT query on the SQLite database. Returns rows as JSON. Use parameter binding for safety.

Execute an INSERT, UPDATE, or DELETE query. Returns affected row count. Use parameter binding for safety.

Create a new table in the database with specified columns and constraints.

List all tables and views in the database with their row counts.

Get detailed schema information for a table including columns, types, and constraints.

Drop (delete) a table from the database. This is irreversible!

List all indexes in the database, optionally filtered by table.

Create an index on one or more columns to improve query performance.

Create an FTS5 full-text search virtual table.

Search an FTS5 table using full-text query syntax.

Rebuild an FTS5 index to optimize search performance.

Get FTS5 match ranking information using bm25.

Calculate the distance between two geographic points using Haversine formula.

Find points within a radius of a center point.

Find points within a rectangular bounding box.

Cluster geographic points into grid cells.

Insert a row with JSON data. Automatically normalizes JSON for consistent storage.

Update a value at a specific JSON path using json_set().

Select rows and optionally extract specific JSON paths.

Query JSON data with path-based filters and projections.

Validate a JSON path syntax without executing a query.

Merge JSON object into existing JSON column using json_patch().

Check if a string is valid JSON.

Extract a value from a JSON column at the specified path using json_extract().

Set a value at a JSON path using json_set(). Creates path if it does not exist.

Remove a value at a JSON path using json_remove().

Get the JSON type (null, true, false, integer, real, text, array, object) at a path.

Get the length of a JSON array at the specified path.

Append a value to a JSON array using json_insert().

Get the keys of a JSON object at the specified path.

Expand a JSON array or object into rows using json_each().

Aggregate column values into a JSON array using json_group_array().

Aggregate key-value pairs into a JSON object using json_group_object().

Format JSON string with indentation for readability.

Get basic statistics (count, sum, avg, min, max) for a numeric column.

Count rows, optionally distinct values in a column.

Aggregate statistics grouped by a column.

Create a histogram with specified number of buckets.

Calculate percentiles (median, quartiles, etc.) for a column.

Calculate Pearson correlation coefficient between two numeric columns.

Get top N values from a column.

Get distinct values from a column.

Get summary statistics for multiple columns at once.

Get frequency distribution of values in a column.

Extract text matching a regex pattern. Processed in JavaScript after fetching data.

Find rows where column matches a regex pattern. Processed in JavaScript.

Split a text column by delimiter into array results.

Concatenate multiple columns with optional separator.

Replace text in a column using SQLite replace() function.

Trim whitespace from text column values.

Convert text to uppercase or lowercase.

Extract a substring from text column using substr().

Create a table optimized for vector storage with JSON vector column.

Store or update a vector in the database.

Store multiple vectors in a batch operation.

Find similar vectors using cosine, euclidean, or dot product similarity.

Retrieve a vector by its ID.

Delete vectors by their IDs.

Count vectors in a table.

Get statistics about vectors in a table.

Get the dimensions of vectors in a table.

Normalize a vector to unit length.

Calculate distance or similarity between two vectors.

Generate a series of numbers using generate_series() virtual table.

Create a view based on a SELECT query.

List all views in the database.

Drop (delete) a view from the database.

Get database storage statistics using dbstat virtual table.

Rebuild the database to reclaim space and optimize structure.

Begin a new transaction. Use immediate or exclusive mode for write-heavy operations.

Commit the current transaction, making all changes permanent.

Rollback the current transaction, discarding all changes.

Create a savepoint within the current transaction for partial rollback.

Release a savepoint, keeping the changes made since it was created.

Rollback to a savepoint, discarding changes made after it was created.

Execute multiple SQL statements in a single transaction. Automatically commits on success or rolls back on error.

Assign sequential row numbers based on ordering. Useful for pagination and ranking.

Calculate rank of rows. RANK leaves gaps after ties, DENSE_RANK does not, PERCENT_RANK gives 0-1 range.

Access previous (LAG) or next (LEAD) row values. Useful for comparing consecutive rows.

Calculate running (cumulative) total. Useful for balance tracking, cumulative metrics.

Calculate moving (rolling) average. Useful for smoothing time series data.

Divide rows into N buckets. E.g., 4 buckets = quartiles, 10 = deciles, 100 = percentiles.