List all configured SQL Server connections and their details (host, database, auth type, security mode)

List all accessible databases on the SQL Server instance

List all schemas in the current database

List all tables in a database, optionally filtered by schema

List all views in a database, optionally filtered by schema

Get detailed column information for a table or view (columns, types, defaults, nullability, identity, computed)

Get foreign key relationships for a table

Get index information for a table

Get constraints (PK, unique, check, default) for a table

Get triggers defined on a table

Execute a read-only SQL query (SELECT). Automatically applies row limits from configuration.

Execute a data modification query (INSERT, UPDATE, DELETE, MERGE). Requires readwrite or admin security mode.

List all stored procedures in a database, optionally filtered by schema

Get parameter information and source code for a stored procedure

Execute a stored procedure with parameters. Requires readwrite or admin security mode.

Get the estimated execution plan for a SQL query (without executing it)

Show currently running queries on the server (from sys.dm_exec_requests)

Get table statistics: row count, total size, index size, and fragmentation

Get index usage statistics: seeks, scans, lookups, and updates (from sys.dm_db_index_usage_stats)

Get missing index suggestions from SQL Server DMVs (sys.dm_db_missing_index_details)

Get SQL Server instance information: version, edition, OS, memory, CPU

Get detailed database information: size, files, status, recovery model

Compare schemas between two databases — shows tables, columns, and indexes that differ (useful for dev vs prod comparison)

Generate TypeScript interface, C# class, or CREATE TABLE script from a table's schema

Generate INSERT statements from existing table data (for migration/seeding)

Generate a Mermaid ER diagram from database foreign key relationships

Get a random sample of rows from a table (useful for understanding data patterns)

Execute a SELECT query and return results as CSV or JSON format

Get top server wait statistics — identifies performance bottlenecks (CPU, I/O, locks, etc.)

Get recent deadlock events from the system_health Extended Events session

Show current blocking chains — which sessions are blocking others

Show long-running open transactions that may be holding locks

Get detailed disk space usage by table in a database

Rebuild or reorganize a fragmented index. Requires admin security mode.

Get recent backup history for a database from msdb

Get top resource-consuming queries from Query Store (SQL Server 2016+). Query Store must be enabled on the database.

Generate INSERT statements with realistic fake/test data based on table schema

Check SQL Server connection health and basic responsiveness