Latest release or the datadog provider for StackQL is now available, enabling SQL-based querying and management of Datadog cloud resources. The new datadog provider includes:
For more see the Datadog Provider User Docs.
⭐ us on GitHub and join our community!
Latest release or the Linode provider for StackQL is available, enabling SQL-based querying and management of Linode cloud resources.
The Linode provider offers comprehensive access to 20 services covering the entire Linode platform, with 136 resources and 425 methods, allowing you to extract data and insights from your Linode environment using familiar SQL syntax.
The provider includes access to:
SELECT
company,
country,
balance,
balance_uninvoiced,
active_since
FROM linode.account.account;
SELECT
id,
engine,
version
FROM linode.databases.engines;
SELECT
available,
plan,
region
FROM linode.regions.availability;
SELECT
id,
label,
region,
status,
type,
ipv4,
tags
FROM linode.linode.instances;
To use the Linode provider, simply register it and set your authentication:
-- Pull the provider
registry pull linode;
-- Set your authentication
SET linode.global.auth.credentialsenvvar = 'LINODE_TOKEN';
⭐ us on GitHub and join our community!
The new deno provider for StackQL is now available, enabling developers to query and manage Deno Deploy resources using familiar SQL syntax. This provider allows you to interact with Deno Deploy's control plane API, giving you complete control over your organizations, projects, deployments, domains, and KV databases through a consistent SQL interface.
The Deno Deploy provider offers comprehensive coverage of the Deno Deploy API, organized into logical services that mirror Deno's resource structure:
| Service | Description |
|---|---|
organization | Manage organizations and analytics |
project | Create and manage projects within organizations |
deployment | Deploy, manage, and monitor serverless applications |
domain | Configure and verify custom domains for your applications |
database | Manage KV databases and KV database backups for your deployments |
With the deno provider for StackQL, you can now include Deno Deploy in your infrastructure-as-code workflows, analytics dashboards, and cross-cloud orchestration processes using the same SQL syntax you use for other cloud providers.
For more information on the Deno Deploy provider for StackQL, see the Deno Deploy Provider Docs which provides detailed documentation for every resource and method, along with ready-to-use SQL examples.
To start using the deno provider, simply pull it from the StackQL registry:
registry pull deno;
You'll need to set up your authentication by exporting your Deno API token:
export DENO_DEPLOY_TOKEN="your_deno_api_token"
Then you can begin querying your Deno Deploy resources:
-- List all projects in an organization
SELECT
id,
name,
description,
createdAt,
updatedAt
FROM deno.project.projects
WHERE organizationId = 'your-org-id';
Results:
|-----------------------------|-------------|--------------------------------------|----------------------|-----------------------------|
| createdAt | description | id | name | updatedAt |
|-----------------------------|-------------|--------------------------------------|----------------------|-----------------------------|
| 2022-12-13T04:20:13.379555Z | | 34f9440f-3275-40e2-b327-2ea65269feb5 | stackql-dev-registry | 2025-09-06T00:47:04.579279Z |
|-----------------------------|-------------|--------------------------------------|----------------------|-----------------------------|
| 2022-12-13T04:16:22.054548Z | | 616de983-3e37-4f44-a99f-b6bb5c59e80a | stackql-registry | 2025-09-06T01:22:46.872203Z |
|-----------------------------|-------------|--------------------------------------|----------------------|-----------------------------|
-- List deployments with key information
SELECT
id,
description,
status,
JSON_EXTRACT(domains, '$[0]') as domain,
JSON_EXTRACT("databases", '$.default') as db_id,
createdAt,
updatedAt
FROM deno.deployment.deployments
WHERE projectId = 'your-project-id'
AND "order" = 'desc';
Results:
|--------------|--------------------------------|---------|----------------------------------------|--------------------------------------|-----------------------------|-----------------------------|
| id | description | status | domain | db_id | createdAt | updatedAt |
|--------------|--------------------------------|---------|----------------------------------------|--------------------------------------|-----------------------------|-----------------------------|
| pe60nqshxq3g | Latest deployment | success | example.com | 8971aec3-f72f-44c4-bc9f-0b2a513bd9fc | 2025-09-06T01:22:41.740151Z | 2025-09-06T01:22:49.067315Z |
|--------------|--------------------------------|---------|----------------------------------------|--------------------------------------|-----------------------------|-----------------------------|
⭐ us on GitHub and join our community!
The latest digitalocean provider for StackQL is available now (v25.09.00345), featuring a comprehensive reorganization of services and resources that better aligns with DigitalOcean's API structure. This update improves discoverability, logical grouping, and overall usability when working with DigitalOcean resources through StackQL, while adding exciting new capabilities like support for Gradient AI Platform through the genai service.
The updated DigitalOcean provider features a more granular and logical organization of services that mirrors DigitalOcean's API architecture more closely. Here is a summary of the services included in the latest digitalocean provider:
| Service | Description |
|---|---|
account | Manages account information, settings, and team configurations |
apps | Manages App Platform deployments for static sites, APIs, and web applications |
billing | Handles billing configurations, invoices, and payment methods |
compute | Controls virtual machines (Droplets), snapshots, and compute resources |
container_registry | Manages container registries and image repositories |
databases | Manages managed database services and configurations |
genai | Provides access to AI capabilities including the Gradient AI Platform |
kubernetes | Controls Kubernetes clusters, node pools, and related resources |
monitoring | Manages monitoring solutions, alerts, and metrics |
networking | Controls VPCs, load balancers, and network configurations |
oneclick | Provides one-click application installations and marketplace solutions |
projects | Organizes resources into logical groups for better management and billing |
serverless | Manages Functions as a Service (FaaS) for event-driven, scalable computing |
spaces | Controls object storage for storing and serving large files and static assets |
vpcs | Manages Virtual Private Cloud networks for isolated resource communications |
The improved organization including service and resource naming and mapping will introduce changes to queries against the previous provider version (v24.11.00274). You can pin the previous version in stackql-deploy or via registry pull in the interim while you make necessary query modifications.
The new DigitalOcean Provider Docs provide comprehensive documentation on how to use the new digitalocean provider including ready-to-use SQL examples for each resource and method. A standout feature is the copy-paste functionality for all SQL queries, making it incredibly easy to:
Compose Infrastructure-as-Code workflows: Each method documentation includes working SQL examples that can be directly copied into your deployment scripts or CI/CD pipelines. Simply click the copy button next to any example to get production-ready SQL code.
Build analytics dashboards: Create sophisticated cross-service queries by combining examples from different resources. The documentation's consistent query formatting makes it simple to join related data across multiple DigitalOcean services.
Develop governance reports: Copy baseline queries and customize them for your specific compliance needs. The pre-formatted SQL provides the perfect starting point for custom reporting.
A standout addition to this release is comprehensive support for DigitalOcean's Gradient AI Platform through the new genai service. This enables developers to:
To start using the updated digitalocean provider, simply pull the latest version from stackql shell or stackql registry command:
registry pull digitalocean;
Then you can begin querying your DigitalOcean resources with SQL:
-- List all droplets
SELECT
id,
name,
status,
size_slug,
JSON_EXTRACT(size, '$.vcpus') as vcpus,
JSON_EXTRACT(size, '$.memory') as memory,
JSON_EXTRACT(size, '$.disk') as disk_size_gb,
JSON_EXTRACT(size, '$.price_hourly') as price_hourly,
JSON_EXTRACT(size, '$.price_monthly') as price_monthly
FROM digitalocean.compute.droplets;
Results:
|-----------|---------------------------------------|--------|------------------------|-------|--------|--------------|--------------|---------------|
| id | name | status | size_slug | vcpus | memory | disk_size_gb | price_hourly | price_monthly |
|-----------|---------------------------------------|--------|------------------------|-------|--------|--------------|--------------|---------------|
| 457265395 | ubuntu-s-1vcpu-1gb-35gb-intel-syd1-01 | active | s-1vcpu-1gb-35gb-intel | 1 | 1024 | 35 | 0.0119 | 8 |
|-----------|---------------------------------------|--------|------------------------|-------|--------|--------------|--------------|---------------|
| 510398669 | pool-urzofvwy7-l5vvz | active | s-2vcpu-4gb | 2 | 4096 | 80 | 0.03571 | 24 |
|-----------|---------------------------------------|--------|------------------------|-------|--------|--------------|--------------|---------------|
-- List all Kubernetes clusters
SELECT
id,
name,
cluster_subnet,
region,
JSON_EXTRACT(status, '$.state') as state
FROM
digitalocean.kubernetes.clusters;
Results:
|--------------------------------------|------------------------------------|----------------|--------|---------|
| id | name | cluster_subnet | region | state |
|--------------------------------------|------------------------------------|----------------|--------|---------|
| 52d8fa14-eca0-46c8-80a8-8aae70a2c82a | k8s-1-33-1-do-2-syd1-1753698369839 | 10.150.0.0/16 | syd1 | running |
|--------------------------------------|------------------------------------|----------------|--------|---------|
The apps services provide access to DigitalOcean's modern deployment platforms. Here's an example of how to list your deployed applications:
-- List all deployed applications
SELECT
id,
default_ingress,
active_deployment,
created_at,
updated_at,
region,
tier_slug
FROM
digitalocean.apps.apps;
The new genai service provides access to DigitalOcean's Gradient AI Platform capabilities. Here's an example of how to list deployed agents:
-- List all deployed AI agents
SELECT
name,
uuid,
url,
project_id,
created_at,
updated_at,
region,
temperature
FROM
digitalocean.genai.agents;
Infrastructure as Code: Manage your DigitalOcean resources alongside other cloud providers in a unified IaC approach, see stackql-deploy.
Cost Optimization: Identify unused resources and opportunities for cost savings with queries that expose pricing information across all resource types.
Security and Compliance: Audit firewall rules, network configurations, and access patterns to ensure compliance with security policies.
Performance Monitoring: Track resource utilization, database performance, and identify optimization opportunities.
Cross-Provider Orchestration: Build workflows that span DigitalOcean and other resource providers, enabling sophisticated data and infrastructure pipelines.
AI-Enhanced Infrastructure: Leverage the new GenAI service to incorporate AI capabilities into your infrastructure management workflows.
Automated Reporting: Create automated reports on DigitalOcean usage, performance, and costs.
The latest DigitalOcean provider includes:
This comprehensive coverage ensures you can manage and query virtually all aspects of your DigitalOcean infrastructure using familiar SQL syntax.
⭐ us on GitHub and join our community!
The latest okta provider for StackQL is available now (v25.09.00341), featuring a comprehensive reorganization of services and resources that better aligns with Okta's API structure. This update improves discoverability, logical grouping, and overall usability when working with Okta resources through StackQL.
The updated Okta provider features a more granular and logical organization of services that mirrors Okta's API architecture more closely. Here is a summary of the services included in the latest okta provider:
| Service | Description |
|---|---|
agentpools | Manages agent pools for on-premises integration and deployment |
api_tokens | Handles API token creation, management, and access control |
apps | Manages Okta application integration, configuration, and assignments |
attack_protection | Configures security controls to prevent various attack vectors |
authenticators | Manages authentication methods, factors, and settings |
authorizationservers | Controls OAuth 2.0 and OIDC authorization servers and policies |
behaviors | Configures end-user behavioral patterns for risk-based authentication |
brands | Manages customization of Okta UI appearance and branding |
captchas | Configures CAPTCHA settings to prevent automated attacks |
device_access | Controls access policies based on device attributes |
device_assurances | Manages device trust requirements and verification |
device_integrations | Configures integrations with MDM and endpoint security tools |
device_posture_checks | Verifies security posture of devices accessing resources |
devices | Manages device enrollment, lifecycle, and inventory |
directories | Handles directory service connections and synchronization |
domains | Manages custom domain configuration for Okta tenant |
email_domains | Controls email domains for user provisioning and validation |
email_servers | Configures email server settings for notifications |
eventhooks | Manages webhook subscriptions for Okta event notifications |
features | Controls feature flags and preview feature management |
first_party_app_settings | Configures settings for Okta-developed applications |
groups | Manages group creation, membership, and rule configuration |
hook_keys | Handles encryption keys for securing hook communications |
iam | Provides core identity and access management functionality |
identity_sources | Manages sources of identity data for user provisioning |
idps | Configures external identity providers for federation |
inlinehooks | Manages customization points within Okta workflows |
integrations | Configures third-party service integrations |
logs | Provides access to system logs and audit events |
logstreams | Manages streaming of log data to external systems |
mappings | Configures attribute mappings between systems |
meta | Provides metadata about the Okta API and environment |
oauth2 | Manages OAuth 2.0 clients, scopes, and tokens |
okta_personal_settings | Controls user-specific preferences and settings |
org | Manages organization-level settings and configurations |
orgs | Handles multi-org deployments and org relationships |
policies | Configures authentication, password, and access policies |
principal_rate_limits | Manages API rate limits for specific principals |
privileged_access | Controls privileged access management settings |
push_providers | Configures push notification delivery services |
rate_limit_settings | Manages global API rate limit configurations |
realm_assignments | Maps users and groups to authentication realms |
realms | Configures authentication realms for different user populations |
risk | Manages risk-based authentication settings and policies |
roles | Controls administrative role assignments and permissions |
security | Provides security settings and configurations |
security_events_providers | Manages integrations with security event sources |
sessions | Controls user session policies and management |
ssf | Configures server-side functions for customization |
templates | Manages templates for emails, notifications, and forms |
threats | Controls threat intelligence settings and configurations |
trustedorigins | Manages CORS and redirect configurations |
users | Handles user lifecycle, profiles, and credentials |
webauthn_registration | Manages WebAuthn/FIDO2 credential registration |
zones | Configures network zones for policy application |
The improved organization including service and resource naming and mapping will introduce changes to queries against the previous provider version (v23.03.00121), you can pin the previous version in stackql-deploy or via registry pull in the interim while you make necessary query modifications.
The new Okta Provider Docs provide comprehensive documentation on how to use the new okta provider including ready-to-use SQL examples for each resource and method. A standout feature is the copy-paste functionality for all SQL queries, making it incredibly easy to:
Compose Infrastructure-as-Code workflows: Each method documentation includes working SQL examples that can be directly copied into your deployment scripts or CI/CD pipelines. Simply click the copy button next to any example to get production-ready SQL code.
Build analytics dashboards: Create sophisticated cross-service queries by combining examples from different resources. The documentation's consistent query formatting makes it simple to join related data across multiple Okta services.
Develop governance reports: Copy baseline queries and customize them for your specific compliance needs. The pre-formatted SQL provides the perfect starting point for custom reporting.
To start using the updated okta provider, simply pull the latest version from stackql shell or stackql registry command:
registry pull okta;
Then you can begin querying your Okta resources with SQL:
-- Get all users and their group assignments
SELECT
u.id,
JSON_EXTRACT(u.profile, '$.email') as email,
u.status,
JSON_EXTRACT(g.profile, '$.name') as group_name
FROM
okta.user.users u
JOIN
okta.group.users gu ON u.id = gu.user_id
JOIN
okta.group.groups g ON gu.group_id = g.id
WHERE subdomain = 'my-company';
-- Report on users login and activity
SELECT
id,
activated,
created,
lastLogin,
lastUpdated,
passwordChanged,
JSON_EXTRACT(profile, '$.email') as email,
JSON_EXTRACT(profile, '$.firstName') as first_name,
JSON_EXTRACT(profile, '$.lastName') as last_name,
status,
statusChanged
FROM okta.users.users
WHERE subdomain = 'my-company';
-- Inventory network zones for security audit
SELECT
name,
type,
status,
gateways,
proxies
FROM
okta.networkzone.zones
WHERE subdomain = 'my-company';
-- Review authorization servers and scopes
SELECT
a.name as auth_server_name,
s.name as scope_name,
s.description
FROM
okta.authorizationserver.authorizationservers a
JOIN
okta.authorizationserver.scopes s ON a.id = s.server_id
WHERE subdomain = 'my-company';
Infrastructure as Code: Manage your Okta resources alongside other cloud providers in a unified IaC approach, see stackql-deploy.
Cost Optimization: Identify unused resources and opportunities for cost savings.
Security and Compliance: Audit account roles, permissions, and access patterns to ensure compliance with security policies.
Performance Monitoring: Track query performance, warehouse utilization, and identify optimization opportunities.
Cross-Provider Orchestration: Build workflows that span Okta and other resource providers, enabling sophisticated data and infrastructure pipelines.
Automated Reporting: Create automated reports on Okta usage, performance, and costs.
⭐ us on GitHub and join our community!