List all online databases on the SQL Server instance

List all schemas in a database

List all tables in a database, optionally filtered by schema

Get column definitions for a table

Get all indexes defined on a table

Get all foreign key relationships for a table

List all views in a database, optionally filtered by schema

Get column definitions and the SQL definition for a view

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

Get the full source definition of a stored procedure

List all synonyms in a database, optionally filtered by schema

Get the base object a synonym points to

List all user-defined functions in a database (scalar, inline table-valued, and multi-statement table-valued), optionally filtered by schema

Get the full source definition of a user-defined function

List all DML triggers in a database, optionally filtered by schema and/or parent table

Get the full source definition of a DML trigger

Get all constraints on a table: PRIMARY KEY, UNIQUE, CHECK, and DEFAULT

Get all extended properties (e.g. MS_Description documentation) for a table, view, procedure, or function — includes both the object-level and all column-level properties

List all sequences in a database, optionally filtered by schema. Shows data type, range, increment, cycling, and current value.

Get row count and disk space usage (total, used, unused) for a table

List all users in a database with their type, default schema, and mapped login

List all database roles and their members. Uses LEFT JOIN so roles with no members are included.

Get all explicit permissions granted on a specific database object

Get SQL Server instance properties: version, edition, collation, clustering, and HA configuration

List all linked servers configured on the SQL Server instance. Requires VIEW ANY DEFINITION or sysadmin — will return an empty result set if the login lacks this permission.

List all SQL Server Agent jobs with their enabled state, category, owner, and last run outcome. Requires membership in SQLAgentUserRole (or higher) in the msdb database.

Get execution history for a SQL Server Agent job. Requires membership in SQLAgentUserRole (or higher) in the msdb database.

List all partition functions in the current database, including range type, partition count, and boundary values

List all partition schemes in the current database, showing which partition function each uses and the mapped filegroups

List all full-text search catalogs in a database with item count, size, and populate status

List all full-text indexes in a database, showing the catalog, indexed columns, and change-tracking state

List all Service Broker queues in a database, optionally filtered by schema

List all Service Broker services in a database and the queue each binds to

List all user-defined types (scalar alias types and table types) in a database, optionally filtered by schema

Get the column definitions for a user-defined table type

List all system-versioned temporal tables in a database, showing the linked history table for each

Execute a read-only SELECT query against the SQL Server. Only SELECT statements (and CTEs using WITH) are permitted. Use TOP or FETCH NEXT in your query for large tables to avoid excessive data transfer. Results are capped at 1000 rows by default.