Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
npx claudepluginhub c-0711/0711-tools --plugin gitchain-supabaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/gitchain-supabase:queryThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Execute SQL queries directly on the GitChain Supabase database.
Generates optimized SQL queries for PostgreSQL, MySQL, SQLite and NoSQL for MongoDB, DynamoDB, Redis; supports ORMs like Prisma. Explains plans, indexes, and performance optimizations.
Generates optimized SQL/NoSQL queries for PostgreSQL, MySQL, MongoDB, Redis; analyzes EXPLAIN plans, designs indexes, troubleshoots slow queries and bottlenecks.
Audits Cloud SQL Postgres health: identifies storage bloat, invalid indexes, analyzes table statistics, manages autovacuum configs, fetches query metrics via PromQL.
Share bugs, ideas, or general feedback.
Execute SQL queries directly on the GitChain Supabase database.
$ARGUMENTS for the query intentSELECT namespace, COUNT(*) as containers,
pg_size_pretty(SUM(pg_column_size(data))) as data_size
FROM containers
GROUP BY namespace ORDER BY containers DESC;
SELECT id, namespace, identifier, data->>'name' as name,
data->'pricing'->>'listPrice' as price
FROM containers
WHERE to_tsvector('english', data::text) @@ to_tsquery($1)
LIMIT 20;
SELECT namespace,
COUNT(*) as total,
COUNT(data->'pricing') as has_pricing,
COUNT(data->'dimensions') as has_dimensions,
ROUND(COUNT(data->'pricing')::numeric / COUNT(*)::numeric * 100, 1) as pricing_pct
FROM containers WHERE type = 'product'
GROUP BY namespace;
Present results as clean markdown tables. Include: