Backend FAQs

Question 1

What is Backend (mcp-backend) and who is it for?

Accepted Answer

Backend (mcp-backend) is a local MCP server designed for studio-based AI clients. It provides comprehensive backend access and management for PostgreSQL, Supabase Storage, Apache Iceberg catalogs, and SQL seed operations.

Question 2

What are the main benefits for developers using Backend?

Accepted Answer

Developers gain robust control over their backend stack, enabling them to execute arbitrary SQL, manage Supabase files, call PostgreSQL RPC functions, and bootstrap Iceberg schemas efficiently, all through a unified server compatible with AI clients.

Question 3

Can Backend interact with Apache Iceberg data lakes?

Accepted Answer

Yes, Backend facilitates interaction with Apache Iceberg by allowing direct querying of Iceberg foreign tables via PostgreSQL FDW and listing tables from an Iceberg REST Catalog, making data lake integration seamless for AI applications.

Question 4

What core databases and storage solutions does Backend integrate with?

Accepted Answer

It offers direct access to PostgreSQL databases (including RLS context), full Supabase Storage operations (list, upload, delete, sync files and buckets), and Apache Iceberg catalog querying with foreign table integration via PostgreSQL FDW.

Question 5

How does Backend simplify SQL seed management?

Accepted Answer

Backend provides tools to list, run, and manage SQL seed files, categorized into 'base/' (e.g., languages, settings) and 'data/' (e.g., users, products). This ensures consistent database configurations and easy setup for development.

Backend

Backend

Características Principales

Casos de Uso

Características Principales

Casos de Uso