Ai Writer in Edge Functions and SQL Editor

[jonathanm841]

Ai tool to write sql queries and edge functions within the UI. Would save a lot of time

[mergisi]

Strong use case — the SQL Editor is where most developers already spend time debugging and iterating, so surfacing AI assistance inline would reduce context switching significantly.

A few thoughts on what this could look like in practice:

For SQL queries: The most useful pattern is natural language → SQL with schema awareness. If Supabase's AI writer has access to the current project's table structure, it could resolve ambiguous queries ("show me recent signups from Europe") into properly joined queries without the user needing to remember exact column names or foreign key relationships.

For Edge Functions: The challenge is more about boilerplate and pattern matching — knowing when to use supabase.from() vs raw SQL, how to handle auth context, error patterns, etc. A code completion layer trained on Supabase-specific patterns would be more useful than a generic LLM here.

For SQL specifically, ai2sql.io takes the natural language → SQL approach and works well as a standalone tool while Supabase builds this natively. The schema context piece is what would make a native integration genuinely better — external tools have to work without it.