gabi-sql-query

Execute SQL queries against the Red Hat Insights RBAC database in stage or prod environments.

11|77|Updated Feb 1, 2019
One-click install
npx skills add https://github.com/RedHatInsights/insights-rbac --skill gabi-sql-query
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: gabi-sql-query
Source: https://github.com/RedHatInsights/insights-rbac/tree/main/.cursor/skills/gabi
Command: npx skills add https://github.com/RedHatInsights/insights-rbac --skill gabi-sql-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill allows users to securely run SQL queries against the RBAC database in staging or production environments, providing direct access to critical data for analysis and troubleshooting.

Core Features & Use Cases

  • Secure Database Access: Execute SQL queries against the RBAC database with proper authentication.
  • Environment Selection: Supports querying both 'stage' and 'prod' environments.
  • Use Case: A user needs to find all users associated with a specific group UUID in the RBAC database. They can use this skill to run a targeted SQL query to retrieve this information efficiently and securely.

Quick Start

Run a SQL query to select all columns from the management_group table for a group with the UUID 'a1b2c3d4-e5f6-7890-1234-567890abcdef' in the stage environment.

Frequently Asked Questions about gabi-sql-query

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

FAQPage Schema
How do I securely query the RBAC database in staging or production environments?

To securely query the RBAC database, execute SQL queries using the Gabi tool. You must provide a valid TOKEN environment variable and explicitly specify the target environment ('stage' or 'prod') for targeted data retrieval.

What do I need to run SQL queries against the Red Hat Insights RBAC database?

Running SQL queries against the RBAC database requires a valid TOKEN environment variable for authentication. You also need to specify the target environment explicitly as either 'stage' or 'prod' to ensure secure and targeted query execution.

How can I find all users associated with a specific group UUID in the RBAC database?

To find users associated with a specific group UUID, run a targeted SQL query against the RBAC database. Select the relevant columns from the management_group table using the group UUID in your query execution.

Can I use this Skill to query both stage and prod Red Hat Insights environments?

Yes, you can query both staging and production Red Hat Insights environments. You must explicitly specify either 'stage' or 'prod' during execution to direct the SQL queries to the correct RBAC database environment securely.

What are the limitations when executing SQL queries against the RBAC database?

Executing SQL queries against the RBAC database requires explicit environment specification and a valid TOKEN. Without proper authentication and environment selection, secure query execution for auditing, debugging, and analysis will not proceed.

Does querying the RBAC database with Gabi support data retrieval for auditing and debugging?

Yes, querying the RBAC database with Gabi facilitates data retrieval specifically for auditing, debugging, and analysis of RBAC configurations. It provides direct access to critical configuration data in staging or production environments.