# SQLite

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.

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y @smithery/cli@latest mcp add node2flow/sqlite

# Browse available tools
npx -y @smithery/cli@latest tool list node2flow/sqlite

# Get full schema for a tool
npx -y @smithery/cli@latest tool get node2flow/sqlite sqlite_query

# Call a tool
npx -y @smithery/cli@latest tool call node2flow/sqlite sqlite_query '{}'
```

## Direct MCP Connection

Endpoint: `https://sqlite--node2flow.run.tools`

**Optional config:**
- `SQLITE_DB_PATH` (query) — Path to SQLite database file (creates if not exists)
- `SQLITE_TIMEOUT` (query) — Busy timeout in ms (default: 5000)

## Tools (15)

- `sqlite_query` — Execute a SELECT query on the SQLite database and return rows as a JSON array. Use this for reading data — supports any…
- `sqlite_execute` — Execute a write statement (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) on the SQLite database. Returns the number of r…
- `sqlite_run_script` — Execute multiple SQL statements in a single transaction. All statements succeed or all fail (atomic). Separate statemen…
- `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 da…
- `sqlite_describe_table` — Get the column schema of a table — column names, data types, NOT NULL constraints, default values, and primary key flag…
- `sqlite_list_indexes` — List all indexes on a table — index name, uniqueness, origin (manual or auto-created), and whether it is a partial inde…
- `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 NU…
- `sqlite_alter_table` — Alter an existing table — add a new column, rename a column, or rename the table. SQLite does not support dropping colu…
- `sqlite_drop_table` — Drop (delete) a table and all its data permanently. This action is irreversible. Use ifExists to avoid errors if the ta…
- `sqlite_create_index` — Create an index on one or more columns to speed up queries. Optionally create a UNIQUE index to enforce uniqueness. Ind…
- `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…
- `sqlite_get_info` — Get database metadata — file path, file size, table count, page count, page size, journal mode, WAL status, encoding, a…
- `sqlite_vacuum` — Optimize and compact the database file by rebuilding it. Reclaims space from deleted rows and defragments the file. Ret…
- `sqlite_integrity_check` — Run PRAGMA integrity_check to verify the database is not corrupted. Returns "ok" if the database is healthy, or a list …

```bash
# Get full input/output schema for a tool
npx -y @smithery/cli@latest tool get node2flow/sqlite <tool-name>
```

## Resources

- `sqlite://server-info` — Connection status and available tools for this SQLite MCP server

## Prompts (2)

- `explore-database` — Guide for exploring and querying a SQLite database
- `manage-schema` — Guide for managing SQLite tables, columns, and indexes

---

License: MIT