List all user-accessible databases on SQL Server instance

List all schemas in database with table and view counts

List all tables and views in a database schema

Get column details (name, type, PK, description) for a table

Get foreign key relationships for a table (helps with JOINs)

Search for tables/columns/descriptions matching a keyword

Execute a read-only SQL SELECT query (automatically validated and row-limited)

Get table statistics including row count, size, and timestamps

Get all indexes for a table with column details

Analyze table data to get distribution statistics for each column

List all stored procedures and functions with parameters

Export table data to JSON or CSV format

Get the SQL definition of a view along with referenced tables

List all constraints (PK, FK, Unique, Check) for a table or all tables

Get SQL Server information including version, edition, and status

Get the full SQL definition of a stored procedure or function

List all database users and their roles

Get detailed permissions for a specific user

Get detailed distribution statistics for a specific column

Get full dependency map for a table (what it depends on and what depends on it)

Get detailed usage information for a specific column (views, procedures, foreign keys, indexes)

Validate data integrity for a table (FK violations, duplicates, null violations)

Get comprehensive data profile for a table including quality metrics

Generate comprehensive schema documentation with tables, views, columns, and relationships

Create entity relationship diagram in Mermaid, PlantUML, or DOT format

Generate REST API documentation from database schema with inferred endpoints and schemas

Generate migration scripts for schema changes with up/down migrations

Compare two schemas to identify differences in tables, views, and procedures

Clear the schema metadata cache to force fresh data from the database

Backup a SQL Server database to a .bak file with optional compression

Restore a SQL Server database from a .bak file

Get the list of data and log files contained in a backup file

Get backup metadata and header information from a .bak file

List recent backup history from msdb, optionally filtered by database name

Create a new SQL Server database with specified options

Get comprehensive summary of a database including statistics, size, schemas, and last backup

List all tables across all databases or in a specific database

Search for tables, columns, or procedures across all databases by keyword

Analyze and suggest index improvements including missing, unused, and fragmented indexes

Analyze query performance using execution statistics DMVs to find slow queries and bottlenecks

Detect circular dependencies in foreign key relationships

Analyze normalization level of tables using heuristic approach (1NF, 2NF, 3NF detection)

Analyze impact of schema changes by finding all dependent objects

Find stored procedures that are not executed recently or never executed

List all triggers in the database with details and dependencies

Audit user permissions for security analysis and compliance

Check active connections to a database (useful before restore)

Disconnect all users from a database by setting access mode (useful before restore)

Kill specific sessions connected to a database