db-query

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'".