Executes a read-only SELECT query. Auto-limits results if no TOP clause present. Blocks destructive operations.

Lists tables in an MSSQL Database, optionally filtered by schema. For server-level access environments, you can specify a database to list tables from.

Lists databases on the SQL Server instance. Requires server-level access. Filtered by environment policies.

Lists all configured database environments available for connection. Shows environment names, descriptions, access levels, and policy restrictions. Use this to discover which environments are available before running queries.

Validates the environments.json configuration file for correctness and security best practices.

Checks include:

• Required fields (name, server, database for database-level; name, server for server-level)

• Valid authentication mode configuration

• Policy consistency (e.g., readonly + allowedTools including write tools)

• Secret placeholder syntax

• Access level configuration validity

• Tier designation consistency

Returns validation results for each environment with errors and warnings.

Lists available named SQL scripts. Scripts are pre-approved SQL templates that can be executed with parameters.

Executes a named SQL script with parameters. Scripts are pre-approved SQL templates. Use list_scripts to see available scripts.

Describes the schema (columns and types) of a specified MSSQL Database table. For server-level access environments, you can specify a database to target.

Searches tables and columns using wildcard patterns to discover schema names.

Profiles a table by analyzing column statistics, data distributions, and sample records. Returns metadata, cardinality info, null counts, and representative samples for each column.

Describes inbound and outbound foreign-key relationships for a given table, including column mappings and referential actions.

Shows what database objects depend on a table, view, or other object. Use for impact analysis before schema changes.

Tests connectivity to a database environment and returns status, latency, and basic server info.

Generates an estimated execution plan (SHOWPLAN_XML) for a SQL query without executing it.