Microsoft Azure SqlManagementClient

Name: SqlManagementClient API
Brand: Azure SQL Management Client
Availability: InStock

★ Only Publicly Available OpenAPI DocumentStorageDatabaseoauth26 EndpointsREST

Install Jentic One Beta

Connect the SqlManagementClient to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the SqlManagementClient, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with SqlManagementClient API.

List all schemas defined inside a specific Azure SQL Database

Retrieve detailed metadata for a named schema in a database

Enumerate every table contained within a given schema

GET STARTED

Start building with SqlManagementClient API

Explore with Jentic

View OpenAPI Document

For Agents

List schemas, tables, and columns inside an Azure SQL Database server so an agent can reason about database structure before running queries.

Use for: List all schemas in my Azure SQL database called sales-prod, Retrieve the column definitions for the orders table in the dbo schema, Find all tables under the analytics schema in an Azure SQL Database, Get metadata for a specific column before generating a SELECT query

Not supported: Does not run SQL queries, manage server-level firewall rules, or provision databases - use for schema, table, and column metadata introspection only.

Use Cases

Patterns agents use SqlManagementClient API for, with concrete tasks.

★ Pre-Query Schema Discovery

Before issuing SQL against an Azure SQL Database, an application or agent often needs to know which schemas, tables, and columns exist on the target server. SqlManagementClient exposes the schema, table, and column resources under a database so callers can enumerate structure without running INFORMATION_SCHEMA queries against the data plane. This keeps schema discovery in the Azure Resource Manager control plane, with the same auth and audit trail as other Azure operations.

List all schemas in the database 'reporting' on Azure SQL server 'analytics-eu' inside resource group 'data-rg', then list the tables in the 'dbo' schema.

Documenting Existing Azure SQL Databases

Teams onboarding to an existing Azure SQL Database deployment frequently need to generate up-to-date documentation of schemas, tables, and columns. SqlManagementClient lets an automated job walk the schema tree resource by resource and emit a Markdown or JSON catalog. Because every call goes through Azure RBAC, only principals with reader rights on the SQL server can produce the documentation.

Walk every schema, table, and column on the Azure SQL server 'finance-prod' in resource group 'finance-rg' and emit a JSON catalog grouped by schema.

Schema-Aware Query Generation by Agents

AI agents that author SQL on behalf of a user need accurate column names and table names; hallucinated identifiers cause query failures and bad data. Through Jentic, an agent can call SqlManagementClient to retrieve the live schema, table, and column definitions for the target database, then ground its generated query in real identifiers. Jentic isolates the Azure OAuth credentials so the agent never handles a refresh token directly.

Use Jentic to load the SqlManagementClient list-columns operation, then call it for the table 'invoices' in schema 'finance' and pass the returned column names to the SQL generation step.

Key Endpoints

6 endpoints — jentic publishes the only available openapi specification for sqlmanagementclient, keeping it validated and agent-ready.

METHOD

PATH

DESCRIPTION

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas

List schemas in a database

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}

Get a specific database schema

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables

List tables in a schema

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}

Get a specific table

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/columns

List columns in a table

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/columns/{columnName}

Get a specific column definition

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas

List schemas in a database

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}

Get a specific database schema

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables

List tables in a schema

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}

Get a specific table

Why Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

Your Azure AD service principal credential is stored once, encrypted, by your own Jentic One instance and injected at execution time. It never enters the agent's prompt, logs, or context.

Intent-based discovery

Agents search Jentic by intent such as 'list columns of an Azure SQL table' or 'list schemas in an Azure SQL database', and Jentic returns the matching Microsoft.Sql operation with its input schema so the agent calls the right endpoint without reading the ARM reference.

Time to first call

FAQs

Specific to using SqlManagementClient API through Jentic.

Why is there no official OpenAPI spec for SqlManagementClient?

Microsoft Azure publishes Swagger fragments for individual ARM services but does not publish a consolidated, validated OpenAPI 3 spec for the SqlManagementClient schema-introspection surface. Jentic generates and maintains this spec so that AI agents and developers can call SqlManagementClient via structured tooling. It is validated against the live Azure Resource Manager API and kept up to date. Get started with Jentic One, the self-hosted execution layer.

What authentication does the SqlManagementClient use?

All endpoints require Azure Active Directory OAuth 2.0, declared as the azure_auth security scheme in the spec with the user_impersonation scope against https://login.microsoftonline.com. Through Jentic, the Azure access token is held in your Jentic One instance and injected at call time so the agent never sees the raw bearer token.

Can I list every table in an Azure SQL database with SqlManagementClient?

Yes. Call GET on /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/schemas/{schemaName}/tables to enumerate tables under a specific schema. To cover the whole database, first list schemas, then iterate this call per schema.

What are the rate limits for the SqlManagementClient?

Calls go through Azure Resource Manager, which applies subscription-level read throttling (typically 12,000 reads per hour per subscription, varying by region and tenant). Throttled responses return HTTP 429 with a Retry-After header; the spec does not encode these limits, so handle them in client code.

How do I introspect Azure SQL columns through Jentic?

Run pip install jentic, search Jentic for 'list columns of an azure sql table', load the SqlManagementClient list-columns operation schema, then execute it with subscriptionId, resourceGroupName, serverName, databaseName, schemaName, and tableName. Jentic returns the column metadata directly without you handling the Azure AD token.

Does SqlManagementClient let me run SQL queries against the database?

No. This is a control-plane API for schema metadata only. To execute queries you connect to the database over TDS using a SQL driver. Use SqlManagementClient first to discover the structure, then use that information to compose data-plane queries.

Can I limit what my agent is allowed to do with the Azure SQL Management Client API?

Yes. Jentic One is self-hosted, so your own rules decide which operations and credentials the agent may use. Because this API puts the subscription, resource group, server, and database in the URL path, you can pin the agent to a single Azure SQL Database. Every operation is a read over schemas, tables, and columns, so you can allow only the introspection calls the agent needs, such as listing schemas or listing a table's columns, and your stored Azure AD service principal credential is injected at call time without ever entering the agent's context.