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.