List Schema Objects
mssql_list_schema_objectsList tables, views, stored procedures, or functions in a SQL Server database. Filter by schema and paginate results to explore database structure.
Instructions
Lists tables, views, stored procedures, or functions in the connected database. Read-only. Supports filtering by schema name and pagination. Example: objectType='tables', schemaName='dbo', limit=20
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max objects (default 20) | |
| offset | No | Skip N objects | |
| objectType | No | Type of objects to list (default: tables) | tables |
| schemaName | No | Filter to a specific schema (e.g. 'dbo') | |
| response_format | No | Output format: 'json' for structured data, 'markdown' for human-readable table | json |