SQLite

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 SQLite database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table browsi...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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