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.

主な機能

CI/CD integration via GitHub Actions and pre-commit hooks
Live query execution tests against local Supabase instances
1 GitHub stars
Comprehensive query performance and response structure reporting
Automated Row Level Security (RLS) policy verification
Static analysis of query strings against generated schema constants

ユースケース

Verifying database queries after a schema migration
Automating security audits for database access policies
Debugging complex nested relationship joins in Supabase

概要

主な機能

CI/CD integration via GitHub Actions and pre-commit hooks
Live query execution tests against local Supabase instances
1 GitHub stars
Comprehensive query performance and response structure reporting
Automated Row Level Security (RLS) policy verification
Static analysis of query strings against generated schema constants

ユースケース

Verifying database queries after a schema migration
Automating security audits for database access policies
Debugging complex nested relationship joins in Supabase