# Microsoft Fabric SQLDatabase REST APIs API > Microsoft Fabric SQLDatabase REST APIs API on Apizie: 13 endpoints (Returns a list of SQL databases from the specified workspace., Creates a SQL database in the specified workspace., Returns properties of the specified SQL database., Updates the properties of the specified SQL database., …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month. - Project key: `analytics:microsoft-fabric-sql-database` - Category: Analytics - Status: byok - Source: https://learn.microsoft.com/rest/api/fabric/ - Page: https://apizie.tech/api/analytics/microsoft-fabric-sql-database - OpenAPI: https://apizie.tech/api/analytics/microsoft-fabric-sql-database/openapi.json ## Endpoints ### Returns a list of SQL databases from the specified workspace. `GET https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-list-sqldatabases` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | recursive | boolean | no | Lists items in a folder and its nested folders, or just a folder only. True - All items in the folder and its nested folders are listed,… | | rootFolderId | string | no | This parameter allows users to filter items based on a specific root folder. If not provided, the workspace is used as the root folder. | | continuationToken | string | no | A token for retrieving the next page of results. | ### Creates a SQL database in the specified workspace. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-create-sqldatabase` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | body | object | yes | JSON request body | ### Returns properties of the specified SQL database. `GET https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-get-sqldatabase` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | sqlDatabaseId | string | yes | The SQL database ID. | ### Updates the properties of the specified SQL database. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-update-sqldatabase` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | sqlDatabaseId | string | yes | The SQL database ID. | | body | object | yes | JSON request body | ### Deletes the specified SQL database. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-delete-sqldatabase` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | sqlDatabaseId | string | yes | The SQL database ID. | | hardDelete | boolean | no | Specifies whether to perform a hard delete. When set to `true`, the item is permanently deleted and cannot be recovered. When set to… | ### Returns the specified SQL database public definition. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-get-sqldatabase-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | sqlDatabaseId | string | yes | The SQL database ID. | | format | string | no | The format of the SQL database public definition. Supported format: `dacpac` and `sqlproj`. If no format is provided, `dacpac` is used. | ### Overrides the definition for the specified SQL database. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-update-sqldatabase-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | sqlDatabaseId | string | yes | The SQL database ID. | | updateMetadata | boolean | no | When set to true and the SQL database.platform file is provided as part of the definition, the item's metadata is updated using the… | | body | object | yes | JSON request body | ### Starts the mirroring of the specified SQL database.. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/mirroring-start-mirroring` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | sqlDatabaseId | string | yes | The SQL database ID. | ### Stops the mirroring of the specified SQL database. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/mirroring-stop-mirroring` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | sqlDatabaseId | string | yes | The SQL database ID. | ### Revalidate Customer‑Managed Key (CMK) of the specified SQL database. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-revalidate-cmk` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | sqlDatabaseId | string | yes | The SQL database ID. | ### Gets the auditing settings on the specified SQL database. `GET https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/sqlaudit-settings-get-sqlaudit-settings` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | sqlDatabaseId | string | yes | The SQL database ID. | ### Updates the auditing settings on the specified SQL database. `POST https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/sqlaudit-settings-update-sqlaudit-settings` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | sqlDatabaseId | string | yes | The SQL database ID. | | body | object | no | JSON request body | ### Gets the list of restorable deleted databases in the workspace. `GET https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-list-restorable-deleted-databases` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | recursive | boolean | no | Lists items in a folder and its nested folders, or just a folder only. True - All items in the folder and its nested folders are listed,… | | rootFolderId | string | no | This parameter allows users to filter items based on a specific root folder. If not provided, the workspace is used as the root folder. | ## Example ``` curl "https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-list-sqldatabases" \ -H "x-api-key: $APIZIE_KEY" \ -H "x-upstream-key: $PROVIDER_KEY" ``` ## FAQ ### How do I call the Microsoft Fabric SQLDatabase REST APIs API? Create a free Apizie key, then send GET https://apizie.tech/v1/analytics:microsoft-fabric-sql-database/items-list-sqldatabases with the header x-api-key. Every endpoint returns { project, data, timestamp }. ### Is the Microsoft Fabric SQLDatabase REST APIs API free on Apizie? Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Microsoft Fabric SQLDatabase REST APIs itself also needs your own key from fabric.microsoft.com. ### Can AI agents use the Microsoft Fabric SQLDatabase REST APIs API? Yes. Add the Apizie MCP server (https://apizie.tech/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key analytics:microsoft-fabric-sql-database. ### What is the status of the Microsoft Fabric SQLDatabase REST APIs API? Needs your own provider key (bring your own key)