← Back to Documentation
Editor Extensions » SQL Push (local)

SQL Push (local)

SQL Push (local)

The "SQL Push (local)" extension allows you to compare and push schema changes from your nuzur data model directly to a database connection registered on one of your local agents — running on your own computer or on a server (VPS) with a self-hosted database.

Unlike the cloud SQL Push Extension, this local push relies on the nuzur local agent daemon running on that machine. This creates a secure, encrypted tunnel to modify your database schema without exposing your database to the internet.

Prerequisites

  1. Ensure the nuzur CLI is installed and your local agent is paired and running. (See Running a 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 database connection registered on that agent.
  • Schema: Select the target schema inside that database.

Once selected:

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

Next steps