Resource Type: Azure > Provider > SQL

The SQL provider offers a range of fully managed relational database services, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. This provider enables users to deploy, manage, and scale SQL databases in the cloud with built-in high availability, security, and performance optimization features, supporting both modern cloud-native applications and existing on-premises workloads.

Resource Context

SQL is a part of the Provider service.

Each SQL lives under a Subscription.

Controls

The primary controls for Azure > Provider > SQL are:

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/azure-provider#/resource/types/sql

Category URI

tmod:@turbot/turbot#/resource/categories/other

GraphQL

query resource(id: "tmod:@turbot/azure-provider#/resource/types/sql") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-provider#/resource/types/sql'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-provider#/resource/types/sql"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-provider#/resource/types/sql';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-provider#/resource/types/sql"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-provider#/resource/types/sql' and notification_type in ('resource_updated', 'resource_created');