SQLite

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 recommendations.

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 understanding.

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.