Developer Tools

SQLite MCP Server

Use Studio chat to drive this server — credentials stay in your workspace.

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

17 tools
Agent guide included
API Key
Start Chatting

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. Requires: pip install mcpbundles.

Data Model

  • Tables — discover names and columns before writing migrations.
  • Ad hoc SQL — parameterized reads and writes through the generic query surface.
  • Inspection — pragma-backed introspection for schema snapshots.

Gotchas

  • Local file: Path to .db file. Proxy for local access.

Tools in this Server (17)

Fetch

Universal fetch tool that retrieves any row or table schema using smart ID routing with colon-separated format. Supports direct row retrieval and sche...

Search

Search SQLite database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table browsi...

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?

SQLite MCP server for lightweight, serverless, self-contained SQL database operations. Perfect for local development, testing, and embedded applications. Access local database files with: pip install mcpbundles It provides 17 tools that AI agents can use through the Model Context Protocol (MCP).

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 17 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

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

What is MCP?

Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.

Use this bundle in 3 steps

  1. Copy the MCP URL above
  2. Open your AI tool and add a new MCP/connector
  3. Paste the URL and follow any auth prompts

Claude Desktop Users

Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.

Pick your tool tab for exact steps

Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.

Ready to chat with SQLite?

Same flow: Studio opens on this server after sign-in. Keep chatting to call tools from the conversation.

SQLite MCP Server & Skill — 17 Tools