skills.rest
ferrarifankid04
ferrarifankid04COMMUNITY
Explore all skills by this author →
GitHub

firebase-data-connect

Builds and deploys Firebase SQL Connect backends with PostgreSQL schemas, authorized operations, and type-safe SDKs.

Updated Aug 6, 2026
Search Tags:#postgresql#backend#graphql#realtime#firebase#sdk generation#data connect
One-click install
npx skills add https://github.com/ferrarifankid04/ai-skills-public --skill firebase-data-connect-ferrarifankid04
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: firebase-data-connect
Source: https://github.com/ferrarifankid04/ai-skills-public/tree/main/antigravity/plugins/firebase/skills/firebase_data_connect_basics
Command: npx skills add https://github.com/ferrarifankid04/ai-skills-public --skill firebase-data-connect-ferrarifankid04

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires firebase-tools, and includes references (resource) components.

What problem does it solve? Setting up a relational database backend with Firebase requires correctly wiring GraphQL schemas, authorization rules, real-time subscriptions, and client SDK generation, which is error-prone without deep knowledge of Firebase SQL Connect (formerly Data Connect). ## Core Features & Use Cases - Schema & Operations Authoring: Define PostgreSQL-backed data models with @table, relationships, and indexes, then write authorized queries and mutations with filtering, pagination, upserts, and transactions. - Realtime & Advanced Features: Configure @refresh subscriptions, vector similarity search, full-text search, and Native SQL for PostGIS or window functions. - Type-Safe SDK Generation: Generate client SDKs for Web, Android, iOS, Flutter, and Node.js Admin, then validate everything with the Firebase CLI emulator and deploy to Cloud SQL. - Use Case: Build a movie review app where users upsert profiles, post reviews secured by auth rules, and subscribe to a live leaderboard, all backed by Cloud SQL for PostgreSQL. ## Quick Start Ask the agent to initialize Firebase SQL Connect in your project and create a schema with queries and mutations for your app's data model.

Frequently Asked Questions about firebase-data-connect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up Firebase Data Connect with PostgreSQL?▼

Run npx firebase-tools init dataconnect to scaffold the dataconnect directory with dataconnect.yaml, schema.gql, and connector files. Then define your tables in schema.gql, write operations, and validate with firebase dataconnect:compile before deploying.

How do I write authorized queries and mutations in Firebase SQL Connect?▼

Use the @auth directive with levels PUBLIC, USER, or NO_ACCESS on each operation, and add @check or @redact for row-level validation. Reference auth.uid via _expr expressions to scope operations to the current user.

When should I use Native SQL instead of GraphQL in Data Connect?▼

Default to Native GraphQL for standard CRUD and filtering since it provides type safety. Use Native SQL only for PostgreSQL-specific features like PostGIS, window functions, or complex aggregations, using _select and _execute with positional parameters.

Does Firebase Data Connect support real-time subscriptions?▼

Yes, single-entity lookups by ID refresh automatically, while list queries need the @refresh directive for time-based polling or event-driven updates tied to specific mutations. Clients consume updates via the subscribe() method in generated SDKs.

Which platforms can use generated Data Connect SDKs?▼

SDK generation supports JavaScript/TypeScript for web, Kotlin for Android, Swift for iOS, Dart for Flutter, and a Node.js Admin SDK. Configure output directories and packages in connector.yaml, then run firebase dataconnect:sdk:generate.

Related Skills

Explore More Software Engineering Skills→
xbg-solutionsxbg-solutions

firebase-local-env-setup

Verify Node.js, install Firebase CLI, and perform first-time login.

Official
Intermediate
nikegeorgian-stacknikegeorgian-stack

firebase-data-connect

Builds and deploys Firebase SQL Connect backends with PostgreSQL schemas, authorized operations, and type-safe SDKs.

Community
Advanced
sitharaj88sitharaj88
1

gcp-eventarc

Generate Eventarc triggers routing GCP events to Cloud Run services.

Community
Advanced
rashideerashidee
3

modelgen-nosql

Extract NoSQL document models from Agile user stories using DDD principles.

Community
Advanced