{"files":{"SKILL.md":"---\nname: sqlmanagementclient\ndescription: \"SqlManagementClient API skill. Use when working with SqlManagementClient for subscriptions. Covers 8 endpoints.\"\nversion: 1.0.0\ngenerator: lapsh\n---\n\n# SqlManagementClient\nAPI version: 2014-04-01\n\n## Auth\nOAuth2\n\n## Base URL\nhttps://management.azure.com\n\n## Setup\n1. Configure auth: OAuth2\n2. GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName} -- gets a server's table auditing policy. table auditing is deprecated, use blob auditing instead.\n3. Explore available endpoints below\n\n## Endpoints\n8 endpoints across 1 group. See references/api-spec.lap for full details.\n\n### Subscriptions\n| Method | Path | Description |\n|--------|------|-------------|\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName} | Gets a server's table auditing policy. Table auditing is deprecated, use blob auditing instead. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName} | Creates or updates a server's table auditing policy. Table auditing is deprecated, use blob auditing instead. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies | Lists a server's table auditing policies. Table auditing is deprecated, use blob auditing instead. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingPolicies/{tableAuditingPolicyName} | Gets a database's table auditing policy. Table auditing is deprecated, use blob auditing instead. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingPolicies/{tableAuditingPolicyName} | Creates or updates a database's table auditing policy. Table auditing is deprecated, use blob auditing instead. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingPolicies | Lists a database's table auditing policies. Table auditing is deprecated, use blob auditing instead. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/{connectionPolicyName} | Gets a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/{connectionPolicyName} | Creates or updates a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead. |\n\n## Common Questions\nMatch user requests to endpoints in references/api-spec.lap. Key patterns:\n- \"Get auditingPolicy details?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName}\n- \"Update a auditingPolicy?\" -> PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName}\n- \"List all auditingPolicies?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies\n- \"Get connectionPolicy details?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/{connectionPolicyName}\n- \"Update a connectionPolicy?\" -> PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/{connectionPolicyName}\n- \"How to authenticate?\" -> See Auth section above\n\n## Response Tips\n- Check response schemas in references/api-spec.lap for field details\n- Create/update endpoints return the modified resource on success\n\n## References\n- Full spec: See references/api-spec.lap for complete endpoint details, parameter tables, and response schemas\n\n> Generated from the official API spec by [LAP](https://lap.sh)\n","references/api-spec.lap":"@lap v0.3\n# Machine-readable API spec. Each @endpoint block is one API call.\n@api SqlManagementClient\n@base https://management.azure.com\n@version 2014-04-01\n@auth OAuth2\n@common_fields {serverName: any # The name of the server.}\n@endpoints 8\n@toc subscriptions(8)\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName}\n@desc Gets a server's table auditing policy. Table auditing is deprecated, use blob auditing instead.\n@required {tableAuditingPolicyName: any # The name of the table auditing policy.}\n@returns(200) Successfully retrieved the server table auditing policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies/{tableAuditingPolicyName}\n@desc Creates or updates a server's table auditing policy. Table auditing is deprecated, use blob auditing instead.\n@required {tableAuditingPolicyName: any # The name of the table auditing policy., parameters: map # The server table auditing policy.}\n@returns(200) Successfully set the server table auditing policy.\n@returns(201) Successfully created the server table auditing policy.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingPolicies\n@desc Lists a server's table auditing policies. Table auditing is deprecated, use blob auditing instead.\n@returns(200) Successfully retrieved the server table auditing policies.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingPolicies/{tableAuditingPolicyName}\n@desc Gets a database's table auditing policy. Table auditing is deprecated, use blob auditing instead.\n@required {databaseName: any # The name of the database for which the table audit policy is defined., tableAuditingPolicyName: any # The name of the table auditing policy.}\n@returns(200) Successfully retrieved the database table auditing policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingPolicies/{tableAuditingPolicyName}\n@desc Creates or updates a database's table auditing policy. Table auditing is deprecated, use blob auditing instead.\n@required {databaseName: any # The name of the database for which the table auditing policy will be defined., tableAuditingPolicyName: any # The name of the table auditing policy., parameters: map # The database table auditing policy.}\n@returns(200) Successfully set the database table auditing policy.\n@returns(201) Successfully created the database table auditing policy.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingPolicies\n@desc Lists a database's table auditing policies. Table auditing is deprecated, use blob auditing instead.\n@required {databaseName: any # The name of the database for which the table audit policy is defined.}\n@returns(200) Successfully retrieved the database table auditing policies.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/{connectionPolicyName}\n@desc Gets a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead.\n@required {databaseName: any # The name of the database for which the connection policy is defined., connectionPolicyName: any # The name of the connection policy.}\n@returns(200) Successfully retrieved the database connection policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/{connectionPolicyName}\n@desc Creates or updates a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead.\n@required {databaseName: any # The name of the database for which the connection policy will be defined., connectionPolicyName: any # The name of the connection policy., parameters: map # The database connection policy.}\n@returns(200) Successfully set the database connection policy.\n@returns(201) Successfully created the database connection policy.\n\n@end\n"}}