No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.

Pulumi Community

Hi, is there a way to get a list of Azure SQL database resources that are in a SQL server or Elastic Pool?

I don't see anything natively in Pulumi to achieve this. There are resources for <https://www.pulumi.com/registry/packages/azure-native/api-docs/sql/getserver/|GetServer>, <https://www.pulumi.com/registry/packages/azure-native/api-docs/sql/getelasticpool/|GetElasticPool> and <https://www.pulumi.com/registry/packages/azure-native/api-docs/sql/getdatabase/|GetDatabase>, but these are for individual resources and specifically for server/elastic pool, don't return databases.

The CLI would be the way I'd about things, using the <https://www.pulumi.com/registry/packages/command/|Pulumi Command Provider> with the *<https://learn.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-list|az sql db list>* command. Note that the `az sql db list` command returns the `master` database as well, so you may want to filter that out depending on what you need to do with the list.