Azure SQL Database Datamasking Policies and Rules

Name: Azure SQL Database Datamasking Policies and Rules API
Brand: Azure SQL Database Datamasking Policies and Rules
Availability: InStock

★ Only Publicly Available OpenAPI DocumentSecurityComplianceoauth24 EndpointsREST

For Agents

Connect the Azure SQL Database Datamasking Policies and Rules to your agent

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

Install Jentic One Beta (Self-Hosted)

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

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 Azure SQL Database Datamasking Policies and Rules API.

Read or update the dataMaskingPolicy on an Azure SQL database to switch masking on or off

Create or update a per-column data masking rule with a masking function (default, email, number, text, custom)

List every data masking rule attached to an Azure SQL database's masking policy

Delete a data masking rule when a column is removed or no longer requires masking

GET STARTED

Start building with Azure SQL Database Datamasking Policies and Rules API

Explore with Jentic

View OpenAPI Document

Jentic publishes the only available OpenAPI document for Azure SQL Database Datamasking Policies and Rules, keeping it validated and agent-ready.

Jentic publishes the only available OpenAPI specification for Azure SQL Database Datamasking Policies and Rules, keeping it validated and agent-ready. The API manages dynamic data masking on Azure SQL databases under Microsoft.Sql, exposing the per-database dataMaskingPolicies resource and its child rules. Through 4 endpoints it supports reading and updating the masking policy and creating, listing, and deleting per-column rules so non-privileged users see masked values for sensitive fields.

Use Cases

Patterns agents use Azure SQL Database Datamasking Policies and Rules API for, with concrete tasks.

★ Mask PII Columns on a Customer Database

Apply dynamic data masking to PII columns (email, phone, ssn) on an Azure SQL database so non-privileged readers see masked values without changing the underlying data. PUT the dataMaskingPolicy to Enabled, then create per-column rules under /dataMaskingPolicies/{policyName}/rules/{ruleName} with the appropriate masking function. The rules apply at query time and are transparent to applications using privileged accounts.

Enable dataMaskingPolicy on database 'customers-db' under server 'prod-sql-eus' and create a rule masking the column 'email' on table 'dbo.customers' with the email masking function

Audit Masking Coverage Across a Database

List every data masking rule on a database and produce an audit showing which sensitive columns are masked and which still expose plaintext values. The list endpoint returns rules with table, column, and masking function so an audit can flag gaps against a sensitive-column inventory. Pair with PUT to remediate gaps in the same automated sweep.

List every data masking rule on database 'customers-db' and emit a CSV of (tableName, columnName, maskingFunction) rows

Decommission a Masking Rule on Schema Change

When a column is dropped from a table, the associated masking rule must be deleted to prevent stale rules from accumulating. DELETE on /dataMaskingPolicies/{policyName}/rules/{ruleName} removes the rule cleanly without touching other rules or the parent policy. This keeps the masking configuration aligned with the database schema across migrations.

Delete the data masking rule named 'email-mask' on database 'customers-db' under server 'prod-sql-eus'

Agent-Driven Masking Policy Enforcement via Jentic

An AI agent uses Jentic to enforce a data masking policy across every Azure SQL database in a subscription: ensuring dataMaskingPolicy is Enabled and the canonical set of rules is in place. The agent searches Jentic for 'list data masking rules on an azure sql database', loads the schema, and chains it into PUT and DELETE operations to converge each database to the policy. Azure AD bearer tokens are sourced from the Jentic vault per call.

Search Jentic for 'list data masking rules on an azure sql database', list rules on every database under server 'prod-sql-eus', and PUT or DELETE rules so each database matches the canonical masking policy

Key Endpoints

4 endpoints — jentic publishes the only available openapi specification for azure sql database datamasking policies and rules, keeping it validated and agent-ready.

METHOD

PATH

DESCRIPTION

PUT

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

Create or update the dataMaskingPolicy on a database

GET

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

Get the dataMaskingPolicy on a database

PUT

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/dataMaskingPolicies/{dataMaskingPolicyName}/rules/{dataMaskingRuleName}

Create or update a data masking rule

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/dataMaskingPolicies/{dataMaskingPolicyName}/rules

List data masking rules under a policy

PUT

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

Create or update the dataMaskingPolicy on a database

GET

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

Get the dataMaskingPolicy on a database

PUT

Create or update a data masking rule

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/dataMaskingPolicies/{dataMaskingPolicyName}/rules

List data masking rules under a policy

Why though Jentic?

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

Credential isolation

Azure AD client credentials are stored encrypted in the Jentic vault. A short-lived bearer token scoped to https://management.azure.com/ is fetched per call; raw client secrets and refresh tokens never reach the agent context.

Intent-based discovery

Agents search Jentic by intent (e.g., 'mask a column on an azure sql database') and receive the matching Microsoft.Sql dataMaskingPolicies operation with its full input schema so the agent calls the right endpoint without browsing the ARM reference.

Time to first call

Direct integration: half a day for ARM auth and CRUD against dataMaskingPolicies and rules. Through Jentic: under an hour from search to first successful call.

Related APIs

Alternatives and complements available in the Jentic catalogue.

Complementary

Azure SQL Database Backup Long Term Retention Policy

Manages long-term backup retention on Azure SQL databases that hold masked data.

Use alongside masking when the agent needs to ensure long-term retention is configured on the same database.

Complementary

Azure SQL Database Disaster Recovery Configuration

Configures failover groups and DR replication on Azure SQL databases.

Use to ensure DR replication is in place on databases whose masking policy is being enforced.

Complementary

Azure SQL Database (checkNameAvailability)

Validates Azure SQL server names during provisioning of the server that hosts the masked database.

Use during initial provisioning; this masking API operates on already-provisioned databases.

FAQs

Specific to using Azure SQL Database Datamasking Policies and Rules API through Jentic.

Why is there no official OpenAPI spec for Azure SQL Database Datamasking Policies and Rules?

Microsoft Azure does not publish an OpenAPI specification. Jentic generates and maintains this spec so that AI agents and developers can call Azure SQL Database Datamasking Policies and Rules via structured tooling. It is validated against the live API and kept up to date. Get started at https://app.jentic.com/sign-up.

What authentication does the Azure SQL Database Datamasking API use?

The API uses Azure Active Directory OAuth 2.0 (the azure_auth scheme) with the user_impersonation scope on https://management.azure.com/. Through Jentic, the bearer token is fetched from the Jentic vault and injected at call time so the agent never sees the raw client secret.

How do I create a data masking rule for a specific column?

PUT to /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/dataMaskingPolicies/{dataMaskingPolicyName}/rules/{dataMaskingRuleName} with a body that includes schemaName, tableName, columnName, and maskingFunction (Default, Email, Number, Text, or CCN).

What are the rate limits for the Azure SQL Database Datamasking API?

The spec does not declare per-API limits; calls are throttled by Azure Resource Manager's per-subscription budget for read and write operations on Microsoft.Sql. On HTTP 429, honour the Retry-After header before retrying.

How do I list every masking rule on a database through Jentic?

Search Jentic for 'list data masking rules on an azure sql database', load the schema for GET /dataMaskingPolicies/{policyName}/rules, and execute it. Jentic injects the Azure AD bearer token automatically; the agent only supplies the server, database, and policy names.

Is the Azure SQL Data Masking API free?

Yes — control plane calls to manage masking policies and rules are free. Dynamic data masking itself is included in Azure SQL Database service tiers at no additional charge.