# Bring Relational Power to Firebase with Firebase Data Connect

DevFeed: [Bring Relational Power to Firebase with Firebase Data Connect](<https://devfeed.tech/articles/bring-relational-power-to-firebase-with-firebase-data-connect-23883.md>)

Original publisher: [Read original article](<https://medium.com/firebase-developers/bring-relational-power-to-firebase-with-firebase-data-connect-e65e5c420ca8?source=rss----8e8b7dc6774d---4>)

Author: Nui Somjin

Published: 2024-12-17T14:09:33Z

Content type: tutorial

Language: en

Sources: [Firebase Developers - Medium](<https://devfeed.tech/sources/firebase-developers-medium.md>)

Topics: [Firebase](<https://devfeed.tech/topics/firebase.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [GraphQL](<https://devfeed.tech/topics/graphql.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [SDKs](<https://devfeed.tech/topics/sdks.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [CRUD](<https://devfeed.tech/topics/crud.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [firebase](<https://devfeed.tech/tags/firebase.md>), [firebase-database](<https://devfeed.tech/tags/firebase-database.md>), [firestore](<https://devfeed.tech/tags/firestore.md>), [graphql](<https://devfeed.tech/tags/graphql.md>), [migrations](<https://devfeed.tech/tags/migrations.md>), [permissions](<https://devfeed.tech/tags/permissions.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sdk](<https://devfeed.tech/tags/sdk.md>), [sql-database](<https://devfeed.tech/tags/sql-database.md>)

## AI overview

This tutorial introduces Firebase Data Connect, a relational database offering that uses PostgreSQL on Google Cloud and a GraphQL interface. It explains how developers define schemas and connectors while Firebase generates database schemas, migrations, type-safe SDKs, CRUD API endpoints, and authorization mechanisms.

## Source excerpt

This article has been translated from its original blog post in Thai Many of us are familiar with Firebase as a robust Backend-as-a-Service, renowned for its NoSQL databases such as Realtime Database (since 2012) and Cloud Firestore (since 2017). However, both have limitations when handling complex queries. The Firebase community has long been requesting a SQL database solution to address redundancy and facilitate complex queries. At the recent Google I/O, Firebase introduced Firebase Data Connect, its first relational database offering 🎉 How Firebase Data Connect WorksApp data flow While Firebase Data Connect interacts with databases, it's more accurately described as an interface. Under the hood, it's leveraging PostgreSQL on GCP Cloud and providing a GraphQL-based bridge to connect clients with the SQL database. Firebase Data Connect capabilities that make working with PostgresSQL easier The Firebase team built Data Connect with the philosophy of 'You write the query, we do the rest.' Developers only need to define two things, and Firebase handles the rest, allowing developers to focus on their application's core logic. "You write the query, we do the rest"Firebase provides (in GraphQL): Data model (schema): This specifies the database schema, including the tables, columns, and data types. Connectors (queries & mutations): These define the operations for creating, reading, updating, and deleting data within the database. Firebase automatically creates: PostgresSQL schema: Generates the SQL commands to create the database structure in PostgreSQL, including migrations. Type-safe SDK: Provides a strongly-typed SDK for client applications (iOS, Android, Web, Flutter) to interact with the database. API Endpoints: Creates API endpoints for clients to perform CRUD operations on the database, complete with authorization mechanisms to control user permissions. For instance, all users might be able to view product listings, but only admins can add new products. We define D