SQLite MCP Server

Connect your account, then chat with AI to run tools.

SQLite MCP server for lightweight, serverless, self-contained SQL database operations. Perfect for local development, testing, and embedded applications. Access local database files with MCPBundles Desktop.

Start chatting

Managed

16 tools

Agent guide included

Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.

Browse all tools

AI Skill
SKILL.md

Domain knowledge for SQLite — workflow patterns, data models, and gotchas for your AI agent.

SQLite

SQLite for lightweight, serverless SQL. Local development, testing, embedded apps. Access local .db files with MCPBundles Desktop.

Data Model

Tables — discover names and columns before writing SQL.
Reads — sqlite_list_rows, search (SQL or structured syntax), or sqlite_execute.
Inspection — pragma-backed introspection and AI schema narration.

Operational order (unfamiliar database)

List tables or AI schema narration — learn table and column names.
Inspect database — schema snapshot for the file.
List rows, search, or execute — never guess column names.

Gotchas

Local file: Absolute path to .db file; MCPBundles Desktop proxy for local access.
Single-row reads: sqlite_list_rows with where on primary key or sqlite_execute — not colon sqlite:row:… tokens (removed).

Tools in this Server (16)

Search SQLite database using SQL queries or structured syntax. Returns ranked results with plain row ids and titles. For pagination use sqlite_list_ro...

Sqlite Analyze Indexes

Analyze indexes for a specific table or all tables. Returns index details, usage statistics, and recommendations for optimization.

Sqlite Analyze Table Size

Analyze estimated table sizes using SQLite page statistics. Returns size estimates for all tables in the database.

Sqlite Execute

Execute SQL write statements (INSERT, UPDATE, DELETE, DDL) on SQLite database. Returns affected row count. Supports parameterized queries for safety.

Sqlite Explain Query

Analyze SQL query performance using EXPLAIN QUERY PLAN. Returns execution plan details including scan types, index usage, and performance recommendati...

Sqlite Find Duplicates

Find duplicate rows in a table based on specified columns. Returns duplicate groups with counts and sample rows.

Sqlite Find Nulls

Analyze NULL values in a table. Returns NULL counts per column and identifies columns with high NULL percentages.

Sqlite Get AI Description

Generate full AI-friendly description of SQLite database schema. Returns all tables with columns, types, and constraints in a format optimized for LLM...

Sqlite Get Relationships

Get all foreign key relationships in the database. Returns a graph structure showing table dependencies and relationships.

Sqlite Get Table Stats

Get detailed statistics for a specific SQLite table including row count, column count, indexes, and foreign keys.

Sqlite Inspect Database

Get detailed SQLite database metadata including version, page size, encoding, table count, and size information.

Sqlite List Rows

List rows from a specific SQLite table with filtering, sorting, and pagination support. Returns structured data with column types and row counts.

Sqlite List Tables

List SQLite tables with rich filtering and metadata options. Supports pattern matching and optional inclusion of columns, indexes, and row counts.

Sqlite Profile Column

Profile a specific column in a SQLite table with statistics including distinct count, null count, min, max, and value distribution.

Sqlite Sample Data

Get random sample rows from a SQLite table for data exploration and understanding data patterns.

Sqlite Suggest Indexes

Suggest indexes for tables based on foreign keys, primary keys, and common query patterns. Returns CREATE INDEX statements.

Frequently Asked Questions

What is the SQLite MCP server?

How do I connect SQLite to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/sqlite. Authentication is handled automatically.

How many tools does SQLite provide?

SQLite provides 16 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does SQLite require?

SQLite uses API Key. SQLite requires credentials. Connect via MCPBundles and authentication is handled automatically.

Setup Instructions

Connect SQLite to any MCP client in minutes

MCP URL

https://mcp.mcpbundles.com/bundle/sqlite

Claude.ai Cursor VS Code VS Code Insiders Goose LM Studio Cherry Studio ChatGPT

One-click install:

Install on Claude.ai Install for organization (admins)

The link prefills the Add custom connector dialog — you still review the values and click Add, then Connect to complete OAuth.

Or add manually

Open claude.ai → Settings → Connectors.
Click the + button and choose Add custom connector.
Set Name to SQLite and paste the MCP URL into Remote MCP server URL.
Click Add. SQLite will appear under Not connected — select it and click Connect to complete OAuth.