CroWall today announced the release of CroDB v1.2, introducing a new table designer for its native macOS database client. Users can now create tables, modify fields, redefine primary keys, and delete tables directly in CroDB, with the exact SQL available for review before anything is executed.

CroDB is a lightweight MySQL and PostgreSQL client built for developers and database operators. Instead of attempting to replicate a full database IDE, it focuses on everyday workflows such as connecting to databases, browsing objects, querying and editing data, running SQL, managing table structures, and importing or exporting data.

From Inspecting Tables to Designing Them

CroDB v1.2 adds an editing mode to the Structure tab. Users can now:
- Add, rename, or remove fields;
- Change field data types and nullability;
- Edit default values and comments;
- Define single-column or composite primary keys.

During editing, fields are clearly marked as New, Modified, or Dropped. A dropped field can be restored at any time before saving, and all pending changes can be reverted together.

The release also allows users to create tables from the database context menu in the sidebar. A new table design remains entirely within its tab until the user explicitly selects “Create Table,” ensuring that nothing is sent to the database server prematurely.

Tables can also be deleted from the sidebar. Before deletion, CroDB displays the complete DROP TABLE statement for confirmation. Once the operation succeeds, any open tabs associated with that table are closed automatically.
Review Every Change Before It Runs

Table structure operations can directly affect production data, so CroDB v1.2 places transparency and deliberate confirmation at the center of the workflow.

When saving structural changes, CroDB first opens a review sheet listing every pending modification alongside the exact SQL statements that will be sent to the server. Potentially destructive operations, such as dropping a field or removing a primary key, are clearly identified as irreversible.

CroDB also explains how changes are applied by each database engine. PostgreSQL redesigns run within a single transaction. With MySQL, DDL statements may be committed individually, so CroDB warns users that a failure could leave the table only partially modified.

On connections marked as Production, saving structural changes or deleting a table requires the user to type the table name as an additional confirmation step. Read-only connections cannot enter structure editing mode, while views and materialized views remain available for inspection only.
CroDB also protects unsaved work. When closing a tab with pending structure changes, the application reports how many changes remain unsaved. Refresh actions that could discard the current design are blocked until the user makes an explicit choice.

Lightweight, Native, and Local-First

Alongside the new table designer, CroDB continues to provide database object browsing, SQL editing and execution, table data filtering and editing, CSV import, and exports in CSV, TSV, JSON, SQL, and Markdown formats.
CroDB requires no account and contains no advertising. Connection settings, query history, favorites, drafts, and preferences remain on the user’s Mac. Saved database passwords are protected by macOS Keychain, while database traffic goes directly to the server configured by the user.

“Efficiency in a database tool is not only about reducing the number of steps,” the CroDB team said. “It is also about making every change clear and controllable. With v1.2, we want table design to feel direct while ensuring users can understand exactly what will happen before anything is executed.”

CroDB v1.2 is available now for macOS 15.0 or later.