SHOW
Used to list items in a collection, for instance show all of the services available in a provider, or show all of the resources available in a given service. Also exposes server metadata such as the current StackQL version.
See also:
[ StackQL Resource Hierarchy ]
Syntax
showStatement::=
SHOW [ EXTENDED ]
{ PROVIDERS | SERVICES | RESOURCES | METHODS | INSERT INTO <resource> | VERSION }
[ { IN | FROM } { <provider> | <service> | <resource> } ]
[ { LIKE <pattern> | WHERE <expression> } ];
Examples
List all providers
List all of the available cloud providers in the installed version of StackQL.
-- Returns all of the available cloud providers
SHOW PROVIDERS;
Returns :
|----------------------|--------------|
| name | version |
|----------------------|--------------|
| aws | v26.03.00379 |
|----------------------|--------------|
| databricks_account | v26.03.00381 |
|----------------------|--------------|
| databricks_workspace | v26.03.00381 |
|----------------------|--------------|
| google | v25.12.00357 |
|----------------------|--------------|
| k8s | v24.12.00276 |
|----------------------|--------------|
List all services in a cloud provider
List all of the services available within a given cloud provider, use the optional EXTENDED keyword to return additional information.
-- Returns all services available in a cloud provider
SHOW EXTENDED SERVICES IN google;
Returns :
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| id | name | title | description |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| compute:v25.12.00357 | compute | Compute Engine API | Creates and runs virtual machines on Google Cloud Platform. |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| storage:v25.12.00357 | storage | Cloud Storage API | Stores and retrieves unstructured object data at global sc... |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| bigquery:v25.12.00357 | bigquery | BigQuery API | A data platform for customers to create, manage, share and... |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| aiplatform:v25.12.00357 | aiplatform | Vertex AI API | Train high-quality custom machine learning models with min... |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| geminicloudassist:v25.12.00357 | geminicloudassist | Gemini Cloud Assist API | The AI-powered assistant for Google Cloud. |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
| ... | ... | ... | ... |
|--------------------------------|-------------------|-------------------------|---------------------------------------------------------------|
List all resources within a cloud provider service
List all of the resources available within a given service of a cloud provider. The optional EXTENDED keyword returns the resource description in addition to the resource name.
-- Returns all resources available in a cloud provider service
SHOW EXTENDED RESOURCES IN google.compute;
Returns :
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| name | id | description |
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| instances | google.compute.instances | Virtual machine instances running on Google Cloud Platform...|
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| disks | google.compute.disks | Persistent block storage volumes attached to compute inst... |
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| networks | google.compute.networks | Virtual private cloud (VPC) networking resources and conf... |
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| backend_services | google.compute.backend_services | Backend services used for load balancing and traffic distr...|
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| firewalls | google.compute.firewalls | Firewall rules controlling ingress and egress network traf...|
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
| ... | ... | ... |
|---------------------------------------------------|--------------------------------------------------|--------------------------------------------------------------|
Show available methods for a resource within a cloud provider service
List all of the methods available for a given resource.
-- Returns all methods available for a cloud provider resource
SHOW EXTENDED METHODS IN google.compute.instances;
Returns :
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| MethodName | RequiredParams | SQLVerb | description |
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| list | project, zone | SELECT | Retrieves the list of instances contained...|
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| insert | project, zone | INSERT | Creates an instance resource in the speci...|
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| delete | instance, project, zone | DELETE | Deletes the specified Instance resource... |
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| start | instance, project, zone | EXEC | Starts an instance that was stopped using...|
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| stop | instance, project, zone | EXEC | Stops a running instance, shutting it dow...|
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
| ... | ... | ... | ... |
|----------------------------------------|--------------------------------|---------|---------------------------------------------|
Generating an INSERT template using the SHOW INSERT command
The SHOW command can be used to generate templates for INSERT statements as shown here:
SHOW INSERT INTO google.compute.addresses;
Returns :
INSERT INTO google.compute.addresses(
project,
region,
data__address,
data__addressType,
data__description,
data__ipVersion,
data__name,
data__network,
data__networkTier,
data__prefixLength,
data__purpose,
data__subnetwork
)
SELECT
'{{ .values.project }}',
'{{ .values.region }}',
'{{ .values.data__address }}',
'{{ .values.data__addressType }}',
'{{ .values.data__description }}',
'{{ .values.data__ipVersion }}',
'{{ .values.data__name }}',
'{{ .values.data__network }}',
'{{ .values.data__networkTier }}',
{{ .values.data__prefixLength }},
'{{ .values.data__purpose }}',
'{{ .values.data__subnetwork }}'
The fields returned can be limited to only those required by the provider, see Creating Infrastructure Templates for examples of this.
This template can then be used along with a
jsonorjsonnetdata file to supply values at run time,for more information see Using Variables.
Show the StackQL version
Return the version of the running StackQL process. Useful in shell, exec, and Postgres-wire server modes when you need to confirm which build is answering queries. The same information is also surfaced through the MCP server_info tool.
-- Returns the version of the running StackQL process
SHOW VERSION;
Returns :
+---------+
| version |
+---------+
| 1.2.3 |
+---------+
Use the optional EXTENDED keyword to also return the git commit, build timestamp, and build platform:
-- Returns version plus build provenance
SHOW EXTENDED VERSION;
Returns :
+---------+---------+----------------------+-----------------+
| version | commit | build_date | platform |
+---------+---------+----------------------+-----------------+
| 1.2.3 | a1b2c3d | 2026-05-15T04:12:00Z | linux/amd64 |
+---------+---------+----------------------+-----------------+
SHOW VERSIONrequires no provider, registry, or authentication configuration and is safe to issue in any session.