db-query
Execute PostgreSQL queries on Supabase database and format results
When & Why to Use This Skill
This Claude skill enables seamless interaction with Supabase databases by executing PostgreSQL queries directly. It streamlines data retrieval, manipulation, and result formatting, allowing developers and data analysts to manage their backend infrastructure through natural language or automated scripts within the Claude environment. By bridging the gap between LLM reasoning and live database execution, it enhances productivity for data-driven tasks.
Use Cases
- Data Retrieval: Quickly fetching specific user records, transaction logs, or application state from a Supabase instance for real-time analysis.
- Database Maintenance: Running targeted UPDATE or DELETE queries to clean up data or modify schema attributes without needing a separate SQL client.
- Automated Reporting: Generating formatted reports by joining multiple tables and aggregating data to provide business insights directly within a conversation.
- Backend Debugging: Inspecting the database state during application development to identify and resolve data-related bugs or inconsistencies.
| name | db-query |
|---|---|
| description | Execute PostgreSQL queries on Supabase database and format results |
db-query
Overview
Execute PostgreSQL queries on Supabase database and format results
This skill was converted from a bash script to follow Anthropic's Agent Skills best practices.
Usage
db-query <command> [options]
Commands
TODO: Extract and document commands from the script
Run db-query --help to see available commands.
When to Use
TODO: Add specific use cases
Scripts
scripts/main.sh- Main functionality (converted from original db-query)
Claude can execute this script directly without loading it into context.
Additional Resources
For detailed information, see:
- reference/migration-notes.md - Conversion notes and TODOs
- reference/examples.md - Usage examples (TODO)
Progressive Disclosure
Consider adding these reference files:
reference/api-reference.md- Detailed command documentationreference/troubleshooting.md- Common issues and solutions