How does it handle RLS testing?

It provides standardized test patterns to verify authenticated vs. anonymous access, ensuring that data isolation policies are strictly enforced.

Can I use this for web apps?

This skill is specifically optimized for Flutter mobile applications. For web-based Supabase projects, you might consider tools like db-lint-manager.

Is it compatible with automated CI/CD pipelines?

Yes, the skill includes pre-configured GitHub Actions workflows and Lefthook pre-commit hooks to automate validation during the development lifecycle.

Does it require a running database instance?

The static analysis component works offline without a database, but the live testing and RLS verification features require a local Supabase instance.

Flutter Supabase Query Testing

Name: Flutter Supabase Query Testing
Author: antoineschaller

byantoineschaller

•

Mobile Development

Validates Flutter Supabase queries through static analysis, live database testing, and RLS verification to ensure production reliability.

The Flutter Query Testing skill provides a robust framework for ensuring the integrity and security of Supabase queries within Flutter applications. It bridges the gap between client-side code and database schema by offering static validation of table/column names, live execution against local instances, and rigorous testing of Row Level Security (RLS) policies. By catching 'column does not exist' errors and unauthorized access attempts early in the development cycle, it streamlines the deployment process and prevents query-related regressions in production environments.

Key Features

01CI/CD integration via GitHub Actions and pre-commit hooks

02Live query execution tests against local Supabase instances

031 GitHub stars

04Comprehensive query performance and response structure reporting

05Automated Row Level Security (RLS) policy verification

06Static analysis of query strings against generated schema constants

Use Cases

01Verifying database queries after a schema migration

02Automating security audits for database access policies

03Debugging complex nested relationship joins in Supabase

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add antoineschaller/cortex-skills flutter-query-testing

For use in Claude.ai and ChatGPT

Download Skill