Return the execution plan for a SQL query to diagnose performance. Use this tool instead of running EXPLAIN directly through readQuery — it provides structured output via EXPLAIN QUERY PLAN.

<when_not_to_use>

• Running actual queries → use readQuery or writeQuery

• Checking table structure → use getTableSchema </when_not_to_use>

<what_it_returns> A JSON array of EXPLAIN QUERY PLAN rows showing how SQLite will scan tables, use indexes, and order operations. </what_it_returns>

Get column definitions and foreign key relationships for a table. Requires table — call listTables first.

<what_it_returns> A JSON object with table and columns keyed by column name, each containing type, nullable, key, default, and foreignKey info. </what_it_returns>

List all tables in the connected SQLite database. Use this tool to discover what tables are available before using other tools.

<what_it_returns> A sorted JSON array of table name strings. </what_it_returns>

List all triggers in the connected SQLite database.

<what_it_returns> A sorted JSON array of trigger name strings. </what_it_returns>

List all views in the connected SQLite database.

<what_it_returns> A sorted JSON array of view name strings. </what_it_returns>

Execute a read-only SQL query. Allowed statements: SELECT, EXPLAIN.

<when_not_to_use>

• Data changes (INSERT, UPDATE, DELETE) → use writeQuery

• Query performance analysis → use explainQuery

• Discovering tables or columns → use listTables or getTableSchema </when_not_to_use>

<what_it_returns> A JSON array of row objects, each keyed by column name. </what_it_returns>