SQLite

You can run an MCP server that exposes full CRUD operations and schema management for multiple SQLite databases. This server lets clients connect to different SQLite files, perform create, read, update, and delete actions, inspect schemas, and run SQLite meta commands through a standard MCP interface, all with strong type safety and clear tooling.

How to use

To work with this MCP server, you connect via an MCP client and target the sqlite_mcp server configuration. You can create tables, insert data, query with select, update existing records, and delete rows. You also retrieve table schemas and run meta commands like .tables or .schema against any selected SQLite database path. The setup supports multiple databases, so you can direct each operation to a different database file as needed.

How to install

Prerequisites: you need Node.js and npm installed on your system.

# Install dependencies
npm install

# Build the project
npm run build

# Run in development mode
npm run dev

# Run tests
npm test

# Run tests with coverage
npm run test:coverage

# Lint code
npm run lint

Configuration and usage notes

The MCP server is configured as a local, stdio-based server that you run via a command like npx against the sqlite-mcp package. The configuration example shows how to expose the server for an MCP client to consume. You can point your MCP client to this standard configuration and use a single server to manage multiple SQLite database files by providing a database path parameter with each operation.

{
  "mcpServers": {
    "sqlite_mcp": {
      "command": "npx",
      "args": ["-y", "git+https://github.com/YUChoe/sqlite-mcp"],
      "disabled": false,
      "autoApprove": []
    }
  }
}

Notes on features you’ll use

• Multi-database support: Each operation can target a specific SQLite database file by providing the database path. This enables managing several databases from a single MCP server instance.

• Full CRUD operations: Create tables, read data, update records, and delete rows across your SQLite databases.

• Schema and metadata access: Create tables, inspect schemas, and query metadata for your tables.

• SQLite meta commands: Support for common meta commands such as .tables, .schema, .indexes, and .pragma.

• Type safety: Implemented with TypeScript and validated with Zod.

• Testing and quality: Property-based testing with fast-check ensures robust behavior.

Available tools

create-table

Create new tables with specified schema.

insert-data

Insert data into existing tables.

select-data

Execute SELECT queries with optional parameters.

get-schema

Retrieve table schema information.

update-data

Execute UPDATE queries with conditions.

delete-data

Execute DELETE queries with conditions.

meta-command

Execute SQLite meta commands like .tables and .schema.