List all schemas in the connected database.

List tables in the database, optionally filtered to a single schema. Returns table_schema and table_name for each.

List views in the database, optionally filtered to a single schema. Returns table_schema and table_name for each.

List stored procedures in the database, optionally filtered to a single schema.

List functions in the database, optionally filtered to a single schema. Includes the return data type.

Get column names, data types, nullability, and primary key info for a table.

Get column names/types for a view, plus its SQL definition (CREATE VIEW body).

Get parameters and the SQL definition (CREATE PROCEDURE body) for a stored procedure. This tool only reads the procedure's metadata — it never executes it.

Get parameters, return type, and the SQL definition (CREATE FUNCTION body) for a function. This tool only reads the function's metadata — it never executes it.

Preview rows from a table (SELECT TOP N *). Max 200 rows, no filtering — use query_table for filtered results.

Select rows from a table with a single WHERE condition (column, operator, value). Column and operator are validated against the real schema. Max 200 rows.

Select across multiple tables/views with explicit join conditions. Every table and column is validated against the real schema (same as browse_table/query_table) — no raw SQL fragments are accepted. Max 200 rows, up to 6 joins.

Run an arbitrary read-only query — CTEs (WITH ...), subqueries, GROUP BY/aggregates, window functions, UNION, ORDER BY, anything a single SELECT statement can express. Only one SELECT (optionally led by a WITH clause) statement is allowed: the query is rejected before it reaches the database if it contains a second statement or any write/DDL/EXEC keyword, and it additionally always runs inside a transaction that gets rolled back afterwards regardless of outcome, as a second line of defense. Results are capped at 500 rows.

Jaro-Winkler fuzzy search over table/view/column/procedure/function names — use this when you don't remember the exact spelling of an object.

Jaro-Winkler fuzzy search over the distinct values of a single text column — use this to find rows whose value is close to (but not an exact match for) a search term. Samples up to sampleSize distinct values server-side, then ranks them client-side.