Forward Curves Data Tool

Forward Curves is a tool that you can use to develop and manage MySQL databases from your Macintosh. It is designed to handle multiple identical databases on the same server. You can easily replicate SQL statements for each selected database on the connected server. This allows you to generate SELECT statements that are UNIONs of alike tables across multiple databases. Similarly, identical tables can be maintained easily by generating ALTER statements for many databases.

For example, you can add a column to a table using the Table Editor.

Main Windows

Then select databases inside the Scope tab. An ALTER statement will be generated for each database per each change and add to the table.

Table Editor

Once you have the SQL you want, replace those statements into the Main Console window and execute.

Console Window

This feature, which we call database scoping, is included in most features within Forward Curves, including table editing, index editing, and applying code snippets. In addition to database scoping, Forward Curves has all the other basic features that you would expect from a database development tool.

  • Create and execute SELECT statements.
  • Maintain and apply SQL templates using optional table and column placeholders.
  • Manager users and grants.
  • Open multiple windows with a connection per each window.
  • Maintain connection settings in encrypted configuration file.
  • Create and edit tables.
  • Create and edit indexes.
  • Manage foreign key constraints.
  • Compare any two databases and generate DDL statements to synchronize their structures.

Click here to see the Data Tool help pages.