--- title: "Year-end recap for Data Connect" description: "Year-end recap for Data Connect" published: "2024-12-20" last_updated: "2024-12-20" authors: - "Cynthia Wang (Developer Relations Engineer)" categories: - "SQL Connect" - "Recap" - "Year in Review" - "Gemini" - "Project IDX" - "PostgreSQL" - "GraphQL" canonical_url: "https://firebase.blog/posts/2024/12/dataconnect-eoy-recap-2024" --- # Year-end recap for Data Connect *Published December 20, 2024 by Cynthia Wang (Developer Relations Engineer)* --- > **Note:** Firebase Data Connect has been renamed to SQL Connect. Learn more in the [SQL Connect announcement](https://firebase.blog/posts/2026/04/whats-new-sql-connect). It’s been an exciting year for Firebase Data Connect! Since our [debut](https://firebase.blog/posts/2024/10/data-connect-public-preview) at Google I/O and to our [public preview launch](https://firebase.blog/posts/2024/05/introducing-firebase-data-connect) in October, we’ve been so inspired by your continuous enthusiasm. As we wrap up the year, let’s take a moment to look back on everything we’ve added since public preview and share a sneak peek at what’s coming next. ### **What’s New** #### **One-Liner Setup** For macOS and Linux developers, setting up Firebase Data Connect in your local environment is now just one command away: ``` curl -sL https://firebase.tools/dataconnect | bash ``` This installs the tools and launches a browser-based IDE or your locally installed VSCode to help you manage schemas and build queries. Windows users, hang tight—we’re working to bring this setup flow to you soon! #### **Gemini Code Assist** GraphQL queries can be tricky, so why not let Gemini handle them? With simple prompts, you can generate GraphQL queries directly in the Firebase console. For example, type: _"Return the top five movies of 2022, sorted by rating"_ ![Gemini Code Assist](https://firebasestorage.googleapis.com/v0/b/first-class-blog.appspot.com/o/posts%2Ffdc_eoy_2024_1_1600x800.webp?alt=media&token=39aa4eea-8b3a-4fe1-8a81-ac53e6cf3075) …and Gemini writes the query for you. Read more about it [here](https://firebase.blog/posts/2024/11/dataconnect-gemini), or [try it out](https://firebase.corp.google.com/project/_/dataconnect) for yourself! #### **See deployed operations in the Firebase console** Head over to the new “Operations” page in the Firebase console to verify your API surface area. Here, all of your deployed connectors and operations are in one place, helping you to verify their structure and requirements. ![Firebase operations page](https://firebasestorage.googleapis.com/v0/b/first-class-blog.appspot.com/o/posts%2Ffdc_eoy_2024_2_1600x800.webp?alt=media&token=417e832c-481f-476e-bcf4-0df213a62374) #### **Authorization Lookups with @check** Custom logic just got easier! The @check directive now supports CEL expressions, making it possible to [authorize mutations](https://firebase.google.com/docs/data-connect/cel-reference) by looking up data in separate tables and validating fields with conditional logic. For example: ``` @check(expr: "this.role == 'editor'", message: "You must be an editor to modify this.") ``` This feature has been a popular ask among users, and we can’t wait to see the creative ways you use it! #### **Quickstarts and codelabs** We’ve added quickstarts for [iOS](https://github.com/firebase/data-connect-ios-sdk/tree/main/Examples/FriendlyFlix), [Dart](https://github.com/firebase/quickstart-flutter/tree/main/data_connect), and [Android](https://github.com/firebase/quickstart-android/tree/master/dataconnect), alongside a [web quickstart](https://github.com/firebase/quickstart-js/tree/master/dataconnect) and [codelab](https://firebase.google.com/codelabs/firebase-dataconnect-web), to help you hit the ground running. Dedicated codelabs for these platforms are also in the works—stay tuned! ![Codelab sample app](https://firebasestorage.googleapis.com/v0/b/first-class-blog.appspot.com/o/posts%2Ffdc_eoy_2024_3_1600x800.webp?alt=media&token=0cefc27e-b361-437e-a8c2-684fd1098fbf) #### **IDX templates** Looking to get started even faster? Choose between an empty template for a fresh start or a complete one with a working example with our [IDX templates](https://idx.google.com/new/dataconnect). These templates allows you to skip the usual setup, installation, and IDE configurations—-just pick a template and start building! ![FDC IDX template](https://firebasestorage.googleapis.com/v0/b/first-class-blog.appspot.com/o/posts%2Ffdc_eoy_2024_5_1600x800.webp?alt=media&token=3420c1c9-9a5c-4fe8-a7d4-d51f6276e114) #### **DataConnect SQL Shell** Need to run raw SQL queries? There’s a new SQL Shell that lets you run queries from the command line: ``` firebase dataconnect:sql:shell >>> Enter your SQL query (or '.exit'): SELECT tablename FROM pg_tables WHERE schemaname = 'public'; >>> SELECT * FROM ``` It’s a great way to manage your database when you need to get a bit more hands on. ### **What’s next** As we gear up for 2025, our engineering team is hard at work bringing new features to Firebase Data Connect. Here’s a sneak peek at what’s coming your way in the new year! **More codelabs:** New codelabs for Dart, iOS, and Android are coming, along with updates to existing ones to cover the latest features. **Sample Apps:** Real world sample apps that demonstrate the power of Data Connect and how they integrate with other Firebase products. We’ve heard a lot of requests for things like web framework bindings, multistep transactions, and more. They’re definitely on our radar. While we don’t have a timeline to share just yet, rest assured that our devs are working hard on these as well as other functionalities. Stay tuned! ### **We’d Love to Hear from You** Before we wrap up, a huge thank you to everyone who’s supported Firebase Data Connect this year. Your feedback and questions have been instrumental in shaping what we’ve built so far—and we’re just getting started! Have thoughts about what’s working or what could be better? What do you love? What could be better? Are there features you’d like to see in the future? Please drop us a note in [Firebase’s UserVoice](https://firebase.uservoice.com/forums/948424-general). Don’t forget to tag your ideas with “Data Connect”. Thank you all again for being with us this past year, and here’s to a new year of creating apps together! ![Sparky delight](https://firebasestorage.googleapis.com/v0/b/first-class-blog.appspot.com/o/posts%2Ffdc_eoy_2024_4_1600x800.webp?alt=media&token=22f10273-319a-40af-ab16-b3049126286d) **Lean more** * [One liner setup](https://firebase.google.com/docs/data-connect/quickstart-local#set_up_the_development_environment) * [Gemini code assist](https://firebase.google.com/docs/data-connect/ai-assistance) * [CEL reference](https://firebase.google.com/docs/data-connect/cel-reference) * [Android quickstart](https://github.com/firebase/quickstart-android/tree/master/dataconnect) * [Dart quickstart](https://github.com/firebase/quickstart-flutter/tree/main/data_connect) * [iOS quickstart](https://github.com/firebase/data-connect-ios-sdk/tree/main/Examples/FriendlyFlix) * [Web quickstart](https://github.com/firebase/quickstart-js/tree/master/dataconnect) * [Web codelab](https://firebase.google.com/codelabs/firebase-dataconnect-web) * [Firebase UserVoice](https://firebase.uservoice.com/forums/948424-general) * [Data Connect blogpost series](https://firebase.blog/posts/2024/10/dataconnect-series-announce)