Sqlite Tools

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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