Sqlite

SQLite is a lightweight, serverless, self-contained SQL database engine. Perfect for local development, testing, and embedded applications.

This Sqlite MCP server is compatible with any MCP client including Claude Desktop, Cursor, and other Model Context Protocol implementations.

Developer Tools

FIELDS

Official Website

Tools From This Provider (17)

Sqlite Explain Query

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

View

Sqlite Analyze Indexes

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

View

Sqlite Find Duplicates

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

View

Sqlite Find Nulls

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

View

Sqlite Analyze Table Size

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

View

Sqlite Get Relationships

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

View

Sqlite Suggest Indexes

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

View

Sqlite Get Table Stats

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

View

Search

Search SQLite database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table browsing. Maximum 100 results per search.

View

Sqlite Profile Column

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

View

Sqlite Sample Data

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

View

Fetch

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

View

Sqlite List Tables

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

View

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.

View

Sqlite Execute

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

View

Sqlite Inspect Database

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

View

Sqlite Get Ai Description

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

View