Supabase FAQs

Question 1

How does this tool help with query writing?

Accepted Answer

By providing your AI assistant with context about your database schema, the tool enables it to suggest more accurate and relevant queries. It helps you write SQL faster and more efficiently.

Question 2

How does the server architecture work?

Accepted Answer

VS Code and Copilot communicate via MCP Protocol with the Supabase MCP Server. The server then interacts with the Supabase Database, retrieving schema information and executing validated queries.

Question 3

Does this tool prevent SQL injection?

Accepted Answer

The tool includes basic SQL injection prevention. It validates query types and restricts execution to allowed query types (defaulting to SELECT-only) for enhanced security.

Question 4

What is the Supabase MCP Server?

Accepted Answer

It's a bridge between AI assistants (like GitHub Copilot) and your Supabase database. It allows the AI to understand your schema, tables, and relationships, and assist with query writing.

Question 5

What are the prerequisites for using this tool?

Accepted Answer

You'll need Node.js 18+, npm or yarn, a Supabase project with an admin API key, VS Code with Copilot/MCP support, and Git.

Supabase

概要

主な機能

ユースケース