---
title: SQL Push (local)
group: editor-extensions
---

## SQL Push (local)

The "SQL Push (local)" extension allows you to compare and push schema changes from your nuzur data model directly to a local database connection running on your machine.

Unlike the cloud [SQL Push Extension](/docs/extensions-push), this local push relies on the **nuzur local agent** daemon running on your computer. This creates a secure, encrypted tunnel to modify your database schema without exposing your server to the internet.

### Prerequisites
1. Ensure the nuzur CLI is installed and your local agent is paired and running. (See [Running a local agent](/docs/local-agent) for detailed instructions).
2. Register a database connection in your local agent.

### Setup & Execution
In the extensions panel, click on the "SQL Push (local)" extension. A modal window will appear where you need to select:

- **Local Agent**: Select which of your paired machines' local agents to use.
- **Connection**: Choose the specific local database connection registered on that agent.
- **Schema**: Select the target schema inside that database.

Once selected:
1. The extension connects to your local database via the agent tunnel and fetches the remote schema.
2. It performs a diff comparison between your nuzur model structure and the local schema.
3. A **SQL Diff** report is displayed, showing the exact SQL commands (e.g., `CREATE TABLE`, `ALTER TABLE`, etc.) required to align the local database with your model.
4. Review the generated SQL script. If approved, click execute to apply the migration script to your local database.

## Next steps
- [Running a local agent](/docs/local-agent)
- [SQL Push Extension](/docs/extensions-push)
- [SQL Gen Extension](/docs/extensions-generate)