Supabase Audit Tables Read

What it does

This skill enables AI agents to securely read and query audit logs stored within Supabase database tables. It allows for the retrieval of historical records regarding user actions, data changes, and system events without modifying the underlying data.

When to use it

• Investigating security incidents by retrieving specific user login attempts or permission grants.
• Auditing compliance requirements to verify who accessed sensitive data during a specific timeframe.
• Debugging application issues by analyzing logs of failed transactions or configuration changes.
• Generating reports on system activity for administrative review or forensic analysis.

Key capabilities

• Reads data from designated Supabase audit tables via SQL queries.
• Filters records based on time ranges, user IDs, or specific event types.
• Returns structured log entries containing timestamps, actor information, and action details.
• Operates within the read-only scope to prevent accidental data modification during investigations.

Example prompts

• "Query the audit_logs table for all failed login attempts from IP address 192.168.1.50 in the last 24 hours."
• "Retrieve a list of users who were granted admin privileges between January 1st and January 31st."
• "Show me the sequence of actions performed by user ID 12345 on the 'users' table this morning."

Tips & gotchas

Ensure your AI agent has appropriate read permissions configured in Supabase before attempting to query sensitive audit logs. Be mindful of large result sets; if a query returns thousands of rows, consider adding specific date filters or pagination logic to manage output size effectively.