Execute a SELECT query against the configured SQL Server database and return formatted results. Only SELECT statements are allowed here — for writes, use sql_run_write.

Execute a write SQL statement (INSERT, UPDATE, DELETE, DROP TABLE, ALTER TABLE, CREATE, TRUNCATE, EXEC stored proc, etc.).

IMPORTANT PERMISSION RULE:

• When confirm is false (default): returns a DRY-RUN PREVIEW — nothing is executed.

• When confirm is true: actually executes the statement.

Always call with confirm=false first to show the user what will happen, then call again with confirm=true only after the user explicitly approves.

List all user tables (and optionally views) in the active database, with row counts.

Show full details about a table: columns with types/nullability/defaults, primary keys, foreign keys, indexes, and row count.

List all stored procedures in the active database.

Get the full definition (source code) of a stored procedure.

Search for a value across all (or specific) columns in a table. Useful when you know a value exists but don't know which column it's in.

Find foreign key violations in a table — records that reference non-existent parent rows (orphaned data). Very useful for diagnosing referential integrity issues.

Get the row count and a sample of rows from a table. Useful for quickly understanding what data exists without writing a full query.

Find rows with NULL values in specified columns. Useful for finding missing/incomplete data that might be causing bugs.

Compare row counts between a parent and child table (joined by FK) to detect missing or extra records. Useful for finding data gaps.

Run a comprehensive diagnostic on a table: counts, NULLs in all columns, FK violations, and recent rows. Great starting point when you notice something wrong.

Get the estimated execution plan for a SELECT query as text (SET SHOWPLAN_ALL). Useful for diagnosing slow queries.