# Firebase SQL Connect API API > Firebase SQL Connect API API on Apizie: 29 endpoints (Gets details of a single Schema., Updates the parameters of a single Schema, and creates a new SchemaRevision with the updated Schema., Deletes a single Schema. Because the schema and connectors must be compatible at all times, if this is…, Lists information about the supported locations for this service. This method lists locations based on the…, …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month. - Project key: `dev-tools:google-firebasedataconnect` - Category: Dev Tools - Status: byok - Source: https://firebase.google.com/docs/data-connect - Page: https://zieapi.vercel.app/api/dev-tools/google-firebasedataconnect - OpenAPI: https://zieapi.vercel.app/api/dev-tools/google-firebasedataconnect/openapi.json Firebase SQL Connect is a relational database service for mobile and web apps that lets you build and scale using a fully-managed PostgreSQL database powered by Cloud SQL. The REST API lets developers manage the… ## Endpoints ### Gets details of a single Schema. `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The name of the schema to retrieve, in the format: ```… | ### Updates the parameters of a single Schema, and creates a new SchemaRevision with the updated Schema. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-patc` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | allowMissing | boolean | no | Optional. If true and the Schema is not found, a new Schema will be created. In this case, `update_mask` is ignored. | | name | string | yes | Identifier. The relative resource name of the schema, in the format: ```… | | requestId | string | no | Optional. An optional request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will… | | updateMask | string | no | Optional. Field mask is used to specify the fields to be overwritten in the Schema resource by the update. The fields specified in the… | | validateOnly | boolean | no | Optional. If set, validate the request and preview the Schema, but do not actually update it. | | body | object | yes | JSON request body | ### Deletes a single Schema. Because the schema and connectors must be compatible at all times, if this is… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-dele` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | allowMissing | boolean | no | Optional. If true and the Schema is not found, the request will succeed but no action will be taken on the server. | | etag | string | no | Optional. The etag of the Schema. If this is provided, it must match the server's etag. | | force | boolean | no | Optional. If set to true, any child resources (i.e. SchemaRevisions) will also be deleted. | | name | string | yes | Required. The name of the schema to delete, in the format: ``` projects/{project}/locations/{location}/services/{service}/schemas/{schema}… | | requestId | string | no | Optional. An optional request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will… | | validateOnly | boolean | no | Optional. If set, validate the request and preview the Schema, but do not actually delete it. | ### Lists information about the supported locations for this service. This method lists locations based on the… `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-list` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | extraLocationTypes | string | no | Optional. Do not use this field unless explicitly documented otherwise. This is primarily for internal usage. | | filter | string | no | A filter to narrow down results to a preferred subset. The filtering language accepts strings like `"displayName=tokyo"`, and is… | | name | string | yes | The resource that owns the locations collection, if applicable. | | pageSize | integer | no | The maximum number of results to return. If not set, the service selects a default. | | pageToken | string | no | A page token received from the `next_page_token` field in the response. Send that page token to receive the subsequent page. | ### Starts asynchronous cancellation on a long-running operation. The server makes a best effort to cancel the… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-operations-cancel` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | The name of the operation resource to be cancelled. | | body | object | yes | JSON request body | ### Lists operations that match the specified filter in the request. If the server doesn't support this method,… `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-operations-list` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | filter | string | no | The standard list filter. | | name | string | yes | The name of the operation's parent resource. | | pageSize | integer | no | The standard list page size. | | pageToken | string | no | The standard list page token. | | returnPartialSuccess | boolean | no | When set to `true`, operations that are reachable are returned as normal, and those that are unreachable are returned in the… | ### Lists Services in a given project and location. `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-list` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | filter | string | no | Optional. Filtering results. | | orderBy | string | no | Optional. Hint for how to order the results. | | pageSize | integer | no | Optional. Requested page size. Server may return fewer items than requested. If unspecified, server will pick an appropriate default. | | pageToken | string | no | Optional. A page token, received from a previous `ListServices` call. Provide this to retrieve the subsequent page. When paginating, all… | | parent | string | yes | Required. Value of parent. | ### Creates a new Service in a given project and location. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-create` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | parent | string | yes | Required. Value of parent. | | requestId | string | no | Optional. An optional request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will… | | serviceId | string | no | Required. The ID to use for the service, which will become the final component of the service's resource name. | | validateOnly | boolean | no | Optional. If set, validate the request and preview the Service, but do not actually create it. | | body | object | yes | JSON request body | ### Execute any GraphQL query or mutation against the Firebase SQL Connect's generated GraphQL schema. Grants… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-execute-grap` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The relative resource name of Firebase SQL Connect service, in the format: ```… | | body | object | yes | JSON request body | ### Execute any GraphQL query against the Firebase SQL Connect's generated GraphQL schema. Grants full read to… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-execute-grap-2` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The relative resource name of Firebase SQL Connect service, in the format: ```… | | body | object | yes | JSON request body | ### Generates a GraphQL query based on a natural language prompt and the provided schema context. This is a… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-generate-que` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The resource name of the service in which to generate the query. Format:… | | body | object | yes | JSON request body | ### Generates GraphQL schema based on a natural language prompt or data description. This allows users to… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-generate-sch` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The resource name of the service in which to generate the schema. Format:… | | body | object | yes | JSON request body | ### Execute introspection query against the Firebase SQL Connect's generated GraphQL schema. GraphQL… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-introspect-g` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The relative resource name of Firebase SQL Connect service, in the format: ```… | | body | object | yes | JSON request body | ### Lists Connectors in a given project and location. `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-connectors-l` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | filter | string | no | Optional. Filtering results. | | orderBy | string | no | Optional. Hint for how to order the results. | | pageSize | integer | no | Optional. Requested page size. Server may return fewer items than requested. If unspecified, server will pick an appropriate default. | | pageToken | string | no | Optional. A page token, received from a previous `ListConnectors` call. Provide this to retrieve the subsequent page. When paginating, all… | | parent | string | yes | Required. Value of parent. | ### Creates a new Connector in a given project and location. The operations are validated against and must be… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-connectors-c` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | connectorId | string | no | Required. The ID to use for the connector, which will become the final component of the connector's resource name. | | parent | string | yes | Required. Value for parent. | | requestId | string | no | Optional. An optional request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will… | | validateOnly | boolean | no | Optional. If set, validate the request and preview the Connector, but do not actually create it. | | body | object | yes | JSON request body | ### Execute a predefined mutation in a Connector. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-connectors-e` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The resource name of the connector to find the predefined mutation, in the format: ```… | | body | object | yes | JSON request body | ### Execute a predefined query in a Connector. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-connectors-e-2` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The resource name of the connector to find the predefined query, in the format: ```… | | body | object | yes | JSON request body | ### Impersonate a mutation defined on a Firebase SQL Connect connector. It grants the admin SDK access to… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-connectors-i` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The resource name of the connector to find the predefined query/mutation, in the format: ```… | | body | object | yes | JSON request body | ### Impersonate a query defined on a Firebase SQL Connect connector. It grants the admin SDK access to queries… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-connectors-i-2` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. The resource name of the connector to find the predefined query/mutation, in the format: ```… | | body | object | yes | JSON request body | ### Executes a dynamic SELECT (read) query on a target PostgreSQL table. Projections, filters, sorting, and… `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-po` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | | firebasedataconnectTable | string | yes | Required. The name of the table to select from. | ### Executes a dynamic INSERT (create) or UPSERT mutation on a target table. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-po-2` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | | firebasedataconnectTable | string | yes | Required. The name of the table to insert into. | | body | object | yes | JSON request body | ### Executes a dynamic UPSERT (replace or create) mutation on a target table identified by primary key filters. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-po-3` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | | firebasedataconnectTable | string | yes | Required. The name of the table to upsert into. | | body | object | yes | JSON request body | ### Executes a dynamic UPDATE (modify) mutation on rows matching the URL filters. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-po-4` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | | firebasedataconnectTable | string | yes | Required. The name of the table to update. | | body | object | yes | JSON request body | ### Executes a dynamic DELETE mutation on rows matching the URL filters. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-po-5` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | | firebasedataconnectTable | string | yes | Required. The name of the table to delete from. | ### Executes a read-only PostgreSQL database function. `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-rp` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectFunction | string | yes | Required. The name of the database function. | | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | ### Executes a PostgreSQL database function. `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-postgrest-rp-2` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | firebasedataconnectFunction | string | yes | Required. The name of the database function. | | firebasedataconnectService | string | yes | Required. The resource name of the service, in the format: `projects/{project}/locations/{location}/services/{service}` | | body | object | yes | JSON request body | ### Lists Schemas in a given project and location. `GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-list` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | filter | string | no | Optional. Filtering results. | | orderBy | string | no | Optional. Hint for how to order the results. | | pageSize | integer | no | Optional. Requested page size. Server may return fewer items than requested. If unspecified, server will pick an appropriate default. | | pageToken | string | no | Optional. A page token, received from a previous `ListSchemas` call. Provide this to retrieve the subsequent page. When paginating, all… | | parent | string | yes | Required. Value of parent. | ### Creates a new Schema in a given project and location. Only creation of `schemas/main` is supported and… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-crea` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | parent | string | yes | Required. Value for parent. | | requestId | string | no | Optional. An optional request ID to identify requests. Specify a unique request ID so that if you must retry your request, the server will… | | schemaId | string | no | Required. The ID to use for the schema, which will become the final component of the schema's resource name. Currently, only `main` is… | | validateOnly | boolean | no | Optional. If set, validate the request and preview the Schema, but do not actually update it. | | body | object | yes | JSON request body | ### Executes SQL migration steps against the active database schema. This operation compares submitted migration… `POST https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-migr` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | name | string | yes | Required. Resource name of the target schema: projects/{project}/locations/{location}/services/{service}/schemas/{schema} Note: Only… | | body | object | yes | JSON request body | ## Example ``` curl "https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-get" \ -H "x-api-key: $APIZIE_KEY" \ -H "x-upstream-key: $PROVIDER_KEY" ``` ## FAQ ### How do I call the Firebase SQL Connect API API? Create a free Apizie key, then send GET https://zieapi.vercel.app/v1/dev-tools:google-firebasedataconnect/firebasedataconnect-projects-locations-services-schemas-get with the header x-api-key. Every endpoint returns { project, data, timestamp }. ### Is the Firebase SQL Connect API API free on Apizie? Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Firebase SQL Connect API itself also needs your own key from googleapis.com. ### Can AI agents use the Firebase SQL Connect API API? Yes. Add the Apizie MCP server (https://zieapi.vercel.app/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key dev-tools:google-firebasedataconnect. ### What is the status of the Firebase SQL Connect API API? Needs your own provider key (bring your own key)