db-mcp (SQLite MCP Server)

Read from the package source without running it. The installed server may list more.

• sqlite_advanced_search

  Advanced search combining exact, fuzzy (Levenshtein), and phonetic (Soundex) matching

• sqlite_analyze

  Analyze table statistics to improve query performance.

• sqlite_analyze_csv_schema

  Analyze a CSV file structure and infer column types. Uses a temporary virtual table.

• sqlite_append_insight

  Add a business insight to the memo://insights resource. Use this to capture key findings during data analysis.

• sqlite_backupwrite action

  Create a backup of the database to a file.

• sqlite_create_csv_tablewrite action

  Create a virtual table from a CSV file. Requires the csv extension.

• sqlite_create_indexwrite action

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

• sqlite_create_json_collectionwrite action

  Create an optimized JSON document collection table with ID, data column, optional timestamps, and JSON path indexes.

• sqlite_create_tablewrite action

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

• sqlite_create_viewwrite action

  Create a view based on a SELECT query.

• sqlite_dbstat

  Get database storage statistics using dbstat virtual table.

• sqlite_describe_table

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

• sqlite_drop_tablewrite action

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

• sqlite_drop_viewwrite action

  Drop (delete) a view from the database.

• sqlite_drop_virtual_tablewrite action

  Drop a virtual table.

• sqlite_fts_createwrite action

  Create an FTS5 full-text search virtual table.

• sqlite_fts_match_info

  Get FTS5 match ranking information using bm25.

• sqlite_fts_rebuild

  Rebuild an FTS5 index to optimize search performance.

• sqlite_fts_search

  Search an FTS5 table using full-text query syntax.

• sqlite_fuzzy_match

  Find fuzzy matches using Levenshtein distance. By default, splits values into tokens and matches against each word (use tokenize:false to match entire value). Use maxDistance 1-3 for similar-length strings.

• sqlite_generate_series

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

• sqlite_geo_bounding_box

  Find points within a rectangular bounding box.

• sqlite_geo_cluster

  Cluster geographic points into grid cells.

• sqlite_geo_distance

  Calculate the distance between two geographic points using Haversine formula.

• sqlite_geo_nearby

  Find points within a radius of a center point.

• sqlite_get_indexes

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

• sqlite_index_stats

  Get detailed statistics for database indexes.

• sqlite_integrity_check

  Check database integrity for corruption or errors.

• sqlite_json_analyze_schema

  Analyze JSON data in a column to infer its schema (types, nullability, counts).

• sqlite_json_array_append

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

• sqlite_json_array_length

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

• sqlite_json_each

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

• sqlite_json_extract

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

• sqlite_json_group_array

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

• sqlite_json_group_object

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

• sqlite_json_insertwrite action

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

• sqlite_json_keys

  Get the distinct keys of JSON objects at the specified path (returns unique keys across all matching rows).

• sqlite_json_merge

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

• sqlite_json_normalize_column

  Normalize JSON data in a column (sort keys, compact format) for consistent storage and comparison.

• sqlite_json_pretty

  Format JSON string with indentation for readability.

• sqlite_json_query

  Query JSON data with path-based filters and projections.

• sqlite_json_removewrite action

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

• sqlite_json_select

  Select rows and optionally extract specific JSON paths.

• sqlite_json_set

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

• sqlite_json_storage_info

  Analyze storage format of a JSON column (text vs JSONB) and report statistics.

• sqlite_json_type

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

• sqlite_json_updatewrite action

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

• sqlite_json_valid

  Check if a string is valid JSON.

• sqlite_json_validate_path

  Validate a JSON path syntax without executing a query.

• sqlite_jsonb_convert

  Convert a text JSON column to JSONB binary format for faster processing. Requires SQLite 3.45+.

• sqlite_list_tables

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

• sqlite_list_views

  List all views in the database.

• sqlite_list_virtual_tables

  List all virtual tables in the database.

• sqlite_optimize

  Optimize database by reindexing and/or analyzing.

• sqlite_phonetic_match

  Find phonetically similar values using Soundex (SQLite native) or Metaphone algorithm.

• sqlite_pragma_compile_options

  Get the compile-time options used to build SQLite. Use the filter parameter to reduce output (~50+ options by default).

• sqlite_pragma_database_list

  List all attached databases.

• sqlite_pragma_optimizewrite action

  Run PRAGMA optimize to improve query performance based on usage patterns.

• sqlite_pragma_settings

  Get or set a PRAGMA value.

• sqlite_pragma_table_info

  Get detailed column information for a table.

• sqlite_read_querywrite action

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

• sqlite_regex_extract

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

• sqlite_regex_match

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

• sqlite_restore

  Restore database from a backup file. WARNING: This replaces the current database.

• sqlite_stats_basic

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

• sqlite_stats_correlation

  Calculate Pearson correlation coefficient between two numeric columns.

• sqlite_stats_count

  Count rows, optionally distinct values in a column.

• sqlite_stats_distinct

  Get distinct values from a column.

• sqlite_stats_frequency

  Get frequency distribution of values in a column.

• sqlite_stats_group_by

  Aggregate statistics grouped by a column.

• sqlite_stats_histogramwrite action

  Create a histogram with specified number of buckets.

• sqlite_stats_hypothesis

  Perform statistical hypothesis tests: one-sample t-test, two-sample t-test, or chi-square test.

• sqlite_stats_outliers

  Detect outliers using IQR (Interquartile Range) or Z-score method.

• sqlite_stats_percentile

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

• sqlite_stats_regression

  Perform linear or polynomial regression analysis between two columns.

• sqlite_stats_summary

  Get summary statistics for multiple columns at once.

• sqlite_stats_top_n

  Get top N values from a column.

• sqlite_text_case

  Convert text to uppercase or lowercase.

• sqlite_text_concat

  Concatenate multiple columns with optional separator.

• sqlite_text_normalize

  Normalize text using Unicode normalization (NFC, NFD, NFKC, NFKD) or strip accents.

• sqlite_text_replace

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

• sqlite_text_split

  Split a text column by delimiter into array results.

• sqlite_text_substring

  Extract a substring from text column using substr().

• sqlite_text_trim

  Trim whitespace from text column values.

• sqlite_text_validate

  Validate text values against patterns: email, phone, URL, UUID, IPv4, or custom regex.

• sqlite_vacuum

  Rebuild the database to reclaim space and optimize structure.

• sqlite_vector_batch_store

  Store multiple vectors in a batch operation.

• sqlite_vector_count

  Count vectors in a table.

• sqlite_vector_create_tablewrite action

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

• sqlite_vector_deletewrite action

  Delete vectors by their IDs.

• sqlite_vector_dimensions

  Get the dimensions of vectors in a table.

• sqlite_vector_distance

  Calculate distance or similarity between two vectors.

• sqlite_vector_get

  Retrieve a vector by its ID.

• sqlite_vector_normalize

  Normalize a vector to unit length.

• sqlite_vector_search

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

• sqlite_vector_stats

  Get statistics about vectors in a table.

• sqlite_vector_store

  Store or update a vector in the database.

• sqlite_verify_backup

  Verify a backup file's integrity without restoring it.

• sqlite_virtual_table_info

  Get metadata about a specific virtual table.

• sqlite_write_querywrite action

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

• Code scan104 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 3 days ago15/15
• Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

db-mcp (SQLite MCP Server): common questions

Is db-mcp (SQLite MCP Server) safe?

Yes, by our scan: it is graded A (92/100). Read the db-mcp (SQLite MCP Server) safety report

How do I install db-mcp (SQLite MCP Server)?

It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.

Does db-mcp (SQLite MCP Server) need an API key?

Not as far as the registry entry and our scan can tell: no credentials are declared or required.

Is db-mcp (SQLite MCP Server) maintained?

The last commit was 18 days ago (2026-09-25). The latest release is v1.0.2.

What can I use instead of db-mcp (SQLite MCP Server)?

Servers from other publishers that do the same job: DBHub MCP server, Mindwtr MCP server and Kubeshark MCP server. Compare all db-mcp (SQLite MCP Server) alternatives.