skills.rest
virgoC0der
virgoC0derCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-query

Query Spanner databases via the Automizely DBP API using go-admin-automizely-cli tokens.

1|Updated Sep 30, 2025
Search Tags:#authentication#database#sql#data-analysis#automizely#spanner#db-query
One-click install
npx skills add https://github.com/virgoC0der/awesome-claude-code --skill db-query
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-query
Source: https://github.com/virgoC0der/awesome-claude-code/tree/main/skills/db-query
Command: npx skills add https://github.com/virgoC0der/awesome-claude-code --skill db-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill enables querying Spanner databases through the Automizely DSP API. It uses the go-admin-automizely-cli library to obtain authentication tokens and execute SQL queries against Spanner databases in different environments.

Core Features & Use Cases

  • Token-based access: Obtain authentication tokens via go-admin-automizely-cli to securely access Spanner databases.
  • Cross-environment queries: Run SQL against Spanner databases in production environments (e.g., aftership-pro-1) and dedicated instances (e.g., p-connectors-usce1).
  • Database discovery: Automatically retrieve database_id from the database list API before executing queries.
  • Use Case: Investigate data issues or verify data states by querying tables like combinable_orders, events, and settings across environments.

Quick Start

Use the db-query skill to run a SQL query against a Spanner database. For example, connect to production environment and execute a query such as "SELECT COUNT(*) FROM orders WHERE created_at >= '2024-01-01'".

Frequently Asked Questions about db-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query a Spanner database securely?▼

Query Spanner databases securely using token-based authentication via go-admin-automizely-cli, which retrieves credentials and executes SQL queries through the Automizely DBP API with automatic database_id discovery.

Can I run SQL queries across production and staging Spanner environments?▼

Yes, this Skill executes SQL queries against Spanner databases in both production environments like aftership-pro-1 and dedicated instances like p-connectors-usce1, supporting cross-environment data verification and debugging.

How do I verify data states across multiple Spanner tables?▼

Execute targeted SQL queries against specific tables such as combinable_orders, events, and settings to investigate data issues, verify states, and profile performance across multiple instances.

What authentication method does this Skill use for Spanner access?▼

The Skill obtains authentication tokens through go-admin-automizely-cli, enabling secure token-based access to Spanner databases without manual credential management.

Do I need to manually discover database IDs before querying?▼

No, the Skill automatically retrieves database_id from the database list API before executing queries, eliminating manual lookup steps.

Related Skills

Explore More Data & Analytics Skills→
openscientist-ioopenscientist-io
44

jgi-lakehouse

Query JGI GOLD and IMG genomic metadata via the Dremio Lakehouse using SQL.

Official
Intermediate
adrianolaselvaadrianolaselva
4

dataql-analysis

Run SQL queries on CSV, JSON, Parquet, and Excel files with DataQL.

Community
Advanced
iankikuiankiku
18

data

Design analytics systems, generate SQL queries, plan event tracking, and build dashboards.

Community
Advanced
Spectra29115Spectra29115

query-integration-data

Query and modify data across integration platforms and data warehouses via SDKs and APIs.

Community
Advanced