From klair-legacy
Help users explore Redshift table schemas and data interactively. Use when user wants to understand table structure, see sample data, or explore column values. Trigger phrases "explore redshift table", "show me table structure", "redshift table schema", "what's in the table"
npx claudepluginhub ai-builder-team/ai-builder-plugin-marketplace --plugin klair-legacyThis skill uses the workspace's default tool permissions.
Help users explore Redshift table schemas and data interactively by fetching column metadata, sample rows, and providing utilities for deeper exploration.
Generates design tokens/docs from CSS/Tailwind/styled-components codebases, audits visual consistency across 10 dimensions, detects AI slop in UI.
Records polished WebM UI demo videos of web apps using Playwright with cursor overlay, natural pacing, and three-phase scripting. Activates for demo, walkthrough, screen recording, or tutorial requests.
Delivers idiomatic Kotlin patterns for null safety, immutability, sealed classes, coroutines, Flows, extensions, DSL builders, and Gradle DSL. Use when writing, reviewing, refactoring, or designing Kotlin code.
Help users explore Redshift table schemas and data interactively by fetching column metadata, sample rows, and providing utilities for deeper exploration.
Use this skill when users want to:
Trigger phrases: "explore redshift table", "show me table structure", "redshift table schema", "what's in the table"
schema.table (e.g., core_finance.maint_report_late_renewals)boto3, redshift-connectorParse Input: Extract schema and table name from user input (format: schema.table)
Fetch Table Metadata:
python utils/get_table_schema.py <schema> <table><schema>_<table>_exploration.md at repo rootPresent Results: Show the user the markdown file location and contents summary
Offer Explorations: Present available exploration options from guidelines/exploration-options.md
Based on user interest, run the appropriate utility:
python utils/get_distinct_values.py <schema> <table> <column>python utils/get_column_stats.py <schema> <table> <column>python utils/get_sample_rows.py <schema> <table> <limit>python utils/run_custom_query.py <schema> <table> "<sql_fragment>"Output exploration results to the same markdown file or separate files as appropriate.
Ask user if they want to keep the exploration files or remove them.
utils/
db_connector.py # Shared AWS Secrets Manager + Redshift connection
test_connection.py # Verify setup and test connection
get_table_schema.py # Fetch columns, types, sample rows
get_distinct_values.py # Get unique values for a column
get_column_stats.py # Get count, nulls, min, max for a column
get_sample_rows.py # Fetch N sample rows
run_custom_query.py # Run custom SQL fragment
guidelines/
exploration-options.md # Detailed descriptions of each exploration type
setup-guide.md # AWS Secrets Manager setup, dependencies
requirements.txt # Python dependencies
klair/redshift-creds<schema>_<table>_exploration.mdpython3 utils/test_connection.py to verify setup before exploring tables