db

Run read-only SQL queries to inspect Supabase database schemas and data.

16|3|Updated May 5, 2026
One-click install
npx skills add https://github.com/Kevin-Liu-01/Agent-Machines --skill db-kevin-liu-01
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db
Source: https://github.com/Kevin-Liu-01/Agent-Machines/tree/main/knowledge/skills/db
Command: npx skills add https://github.com/Kevin-Liu-01/Agent-Machines --skill db-kevin-liu-01

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Provides a safe, read-only interface to explore database schemas and data across local and remote Supabase instances.

Core Features & Use Cases

  • Read-only queries: Enforce --readonly to ensure no mutations during exploration.
  • Environment scope: Works across local, dev, preview, and prod environments with per-environment database references.
  • Quick data investigation: Generate fast schema overviews or sample data dumps to understand tables, columns, and relations.
  • Use Case: When debugging migrations or answering questions about database state in a multi-environment setup.

Quick Start

Run a sample read-only query with the included script to see results.

Frequently Asked Questions about db

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

FAQPage Schema
How do I run read-only SQL queries on a Supabase database?

You can explore Supabase database schemas by running the included query script with the --readonly flag. This generates fast schema overviews and sample data dumps, allowing you to understand tables, columns, and relations safely without risking mutations.

Can I inspect database schemas across different local and remote environments?

Yes, you can inspect database schemas across local, dev, preview, and prod environments by using the --env flag. This allows you to query per-environment database references to compare states and review migrations safely.

How do I prevent accidental data mutations when debugging a Supabase database?

To prevent accidental data mutations when debugging a Supabase database, enforce the --readonly flag in the query script. This guarantees a safe exploration workflow by strictly blocking any write or mutation operations.

What is the best way to investigate table data during a Supabase migration review?

The best way to investigate table data during a Supabase migration review is to use the read-only SQL query script. It allows you to safely generate sample data dumps and inspect schema changes across different environments without altering the database state.

Does this database query tool support output formatting for query results?

Yes, the database query tool supports output formatting for query results through the --format flag. This allows you to customize the presentation of schema overviews and sample data dumps returned during your read-only investigation.