Supabase Audit Tables List

The supabase-audit-tables-list skill enables AI agents to automatically discover and enumerate all tables within a Supabase project. It provides a comprehensive inventory of database schemas, allowing agents to understand the data structure before performing security audits or penetration tests. This capability is essential for mapping out potential attack surfaces in cloud-based PostgreSQL databases managed by Supabase.

When to use it

• Initiating a security assessment to identify which tables hold sensitive user data or credentials.
• Generating a baseline schema report to compare against expected production configurations.
• Preparing an AI agent to write specific SQL queries for vulnerability scanning across known datasets.
• Validating that unauthorized tables have not been created during recent deployments.

Key capabilities

• Automatically lists every table name available in the connected Supabase instance.
• Provides a structured overview of the database schema without requiring manual inspection.
• Integrates directly with Supabase's metadata to ensure real-time accuracy of table inventories.

Example prompts

• "List all tables in my Supabase project so I can begin reviewing them for SQL injection vulnerabilities."
• "Generate a report of every table name and its associated schema details from this Supabase connection."
• "Identify all user-related tables in the database to prepare for a privacy compliance audit."

Tips & gotchas

Ensure your AI agent has the necessary read permissions on the Supabase project, as listing tables requires access to the underlying PostgreSQL metadata. This skill only reveals table names and does not expose column data or row contents unless explicitly queried separately.