Name: SQLite
Author: node2flow

Что умеет

Sqlite Query: 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 qu

Sqlite Execute: 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 f

Sqlite Run Script: 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 op

Local MCP server for SQLite databases — query, manage schema, tables, indexes, and transactions through 15 tools. Install locally via npx only — each user gets their own database.

Features:

Execute SQL queries and statements with parameter binding
Full schema management (tables, columns, indexes, foreign keys)
Database analysis (size, table stats, integrity check)
WAL mode enabled for better concurrency

Install (Claude Desktop / Cursor): npx -y @node2flow/sqlite-mcp

Tool categories:

Query (3): execute_query, execute_run, execute_many
Schema (4): list_tables, describe_table, list_indexes, list_foreign_keys
Table (3): create_table, alter_table, drop_table
Index (2): create_index, drop_index
Database (3): get_info, vacuum, integrity_check

Configuration:

SQLITE_DB_PATH (required) — Path to your local SQLite database file
SQLITE_TIMEOUT (optional) — Busy timeout in milliseconds (default: 5000)

Note: This is a local-only tool. Install via npx to use your own database files.

sqlite_query	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.
sqlite_execute	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.
sqlite_run_script	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.
sqlite_list_tables	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.
sqlite_describe_table	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.
sqlite_list_indexes	List all indexes on a table — index name, uniqueness, origin (manual or auto-created), and whether it is a partial index.
sqlite_list_foreign_keys	List foreign key constraints on a table — referenced table, local and remote columns, ON UPDATE and ON DELETE actions.
sqlite_create_table	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.
sqlite_alter_table	Alter an existing table — add a new column, rename a column, or rename the table. SQLite does not support dropping columns via ALTER TABLE.
sqlite_drop_table	Drop (delete) a table and all its data permanently. This action is irreversible. Use ifExists to avoid errors if the table does not exist.
sqlite_create_index	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.
sqlite_drop_index	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.
sqlite_get_info	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.
sqlite_vacuum	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.
sqlite_integrity_check	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.

SQLite

Что умеет

Какие данные видит

Нужен ли аккаунт