Skip to main content

Latest Linode Provider for StackQL Available

· One min read
Jeffrey Aven
Technologist and Cloud Consultant

Latest release or the Linode provider for StackQL is available, enabling SQL-based querying and management of Linode cloud resources.

Provider Overview​

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.

Key Services​

The provider includes access to:

  • Compute: Manage Linode instances and configurations
  • Storage: Control volumes and object storage
  • Networking: Handle IPs, VLANs, VPCs, and firewall rules
  • Kubernetes: Administer LKE clusters and node pools
  • Databases: Manage Linode's database service
  • Account & Billing: Access account information and billing details

Example Queries​

Get Account Information​

SELECT 
  company,
  country,
  balance,
  balance_uninvoiced,
  active_since
FROM linode.account.account;

List Database Engines​

SELECT
  id,
  engine,
  version
FROM linode.databases.engines;

View Regional Availability​

SELECT
  available,
  plan,
  region
FROM linode.regions.availability;

List Linode Instances​

SELECT
  id,
  label,
  region,
  status,
  type,
  ipv4,
  tags
FROM linode.linode.instances;

Getting Started​

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!