sql-admin-api

Automate Oxla SQL cluster admin via API for TLS, logging, health checks, and Prometheus metrics on port 9090.

6|3|Updated May 31, 2026
One-click install
npx skills add https://github.com/redpanda-data/skills --skill sql-admin-api
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sql-admin-api
Source: https://github.com/redpanda-data/skills/tree/main/skills/sql-admin-api
Command: npx skills add https://github.com/redpanda-data/skills --skill sql-admin-api

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires curl, python3, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Centralizes and simplifies the management of Oxla's SQL cluster by exposing a dedicated admin API for configuration, runtime controls, health checks, and observability.

Core Features & Use Cases

  • Centralized admin surface for cluster configuration, TLS, and admin endpoints.
  • Runtime control over logging via GetLogLevel/SetLogLevel, with immediate effect.
  • Observability through health checks and Prometheus metrics exposed on standard ports.

Quick Start

Use the admin API on port 9090 to retrieve status, adjust log levels, and verify health.

Frequently Asked Questions about sql-admin-api

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

FAQPage Schema
How do I change the log level on an Oxla SQL cluster at runtime?

You can change the Oxla SQL cluster log level at runtime by calling the SetLogLevel admin API endpoint on port 9090, which applies the new logging configuration with immediate effect across single-node and deployment environments.

What is the best way to monitor Oxla SQL cluster health and metrics?

Monitoring Oxla SQL cluster health and metrics is best handled through the admin API on port 9090, which exposes health check endpoints and standard Prometheus metrics for comprehensive observability of your deployment.

Does the Oxla admin API support TLS for secure cluster management?

Yes, the Oxla admin API supports TLS setup for secure cluster management, allowing you to configure encrypted communications over port 9090 when administering your SQL cluster runtime controls and configuration.

Do I need curl and python3 to administer an Oxla SQL cluster via API?

Yes, you need curl and python3 to administer an Oxla SQL cluster via the admin API, as these dependencies are required to execute the scripts that interact with the management utilities and REST endpoints.

How do I retrieve the current logging configuration of an Oxla SQL deployment?

To retrieve the current logging configuration of an Oxla SQL deployment, use the LoggingService GetLogLevel admin API endpoint over port 9090, which returns the active log level settings for your cluster.

Can I use the admin API for centralized configuration of single-node and distributed Oxla deployments?

Yes, you can use the admin API for centralized configuration of single-node and distributed Oxla deployments, providing a unified admin surface for cluster configuration, TLS setup, and operational controls across both environments.