---
title: "Compare database schema"
method: GET
path: "/projects/{project_id}/branches/{branch_id}/compare_schema"
tags: ["Branch"]
---

# Compare database schema

`GET /projects/{project_id}/branches/{branch_id}/compare_schema`

Compares the schema from the specified database with another branch's schema.

## Path parameters

- `project_id` string, required
- `branch_id` string, required

## Query parameters

- `base_branch_id` string
- `db_name` string, required
- `lsn` string
- `timestamp` string, date-time
- `base_lsn` string
- `base_timestamp` string, date-time

## Response `200`

Difference between the schemas

- BranchSchemaCompareResponse
  - `diff` string

## Other responses

- `default` — General Error. The request may or may not be safe to retry, depending on the HTTP method, response status code, and whether a response was received. - If no response is returned from the API, a network error or timeout likely occurred. - In some cases, the request may have reached the server and been successfully processed, but the response failed to reach the client. As a result, retrying non-idempotent requests can lead to unintended results. The following HTTP methods are considered non-idempotent: `POST`, `PATCH`, `DELETE`, and `PUT`. Retrying these methods is generally **not safe**. The following methods are considered idempotent: `GET`, `HEAD`, and `OPTIONS`. Retrying these methods is **safe** in the event of a network error or timeout. Any request that returns a `503 Service Unavailable` response is always safe to retry. Any request that returns a `423 Locked` response is safe to retry. `423 Locked` indicates that the resource is temporarily locked, for example, due to another operation in progress.

---

[API](https://skmtc.dev/neon/apis/neon-api.md) · [All operations](https://skmtc.dev/neon/apis/neon-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/neon/neon-api/revisions/cfde79a5c713/schema)