Screenshots

Description

=== 100% Free - The Best Database Management GUI for ===
=== SQLite, MS SQL Server, MariaDB, mySQL, PostgreSQL and Valentina databases ===

Valentina Studio brings you powerful, visual editors for your data including:
* Schema Editor (tree view and column view) - create and modify all schema objects of supported databases: Tables, Views, Fields, Enums, Links, Constraints, Triggers, Indexes, Stored Procedures, ...
* Diagram Editor - design new diagrams or do reverse engineering, e.i explore existing databases visually.
* Data Editor - easily browse table records in the grid, modify records, an inline edit of values, sort, filter records and save favorite filters, preview images, hex editors for binary values, ...
* Related Data Editor - easily learn and manage linked records of two tables, link/unlink records by a mouse click, do set operations over linked records, ...
* SQL Editor - with color syntax, auto-completion, recent and saved favorite queries, templates, console with error/warning reporting, ...
* Query Editor - build SQL queries visually using just a few mouse clicks
* Server Admin - where you can manage users, learn logs and other parameters of servers.

Open as many editors as you like at the same time for different databases/servers opened in tab-panels. You also get different DB related utilities, including: Import/Export, Dumps, Diagnose, Clone, Reindex, ...

Valentina Studio uses iCloud to share bookmarks between your devices!


*** See also: Valentina Studio Pro ($199 only) ***

Get Valentina Studio Pro as an in-app purchase (pay only once) to get additional advanced pro-features such as:

* Report Editor - visual editor of Valentina Reports that can be saved into Valentina Project file (.vsp). Reports can use as datasource MS SQL, MySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
* Form Editor - visual editor of Valentina Forms that can be saved into Valentina Project file (.vsp). Forms can use all supported databases as the datasource.
* Data Editor - enables go to parent record function.
* Data Editor Layouts - save columns and their order as a named layout
* Data Editor Multiple Update - update few records at once.
* Data Transfer - copy data between different databases
* Diagram Editor - enables forward engineering - i.e. generation of SQL scripts for new/changed database objects.
* Dump Wizard - enables filter for tables to select them for a dump.
* Error Lookup - search for error description by its code.
* Keyboard Shortcuts - enables the ability to redefine the shortcuts and create own shortcut sets.
* Object Colors - enables marking objects with specific colors.
* Query Editor - enables the ability to copy the generated query.
* Schema Cache - save and reuse the schema cache.
* Schema Editor - copy one or few schema objects using drag&drop mechanism.
* Schema Editor - expanding and collapsing the tree items with subitems using OPTION + click
* Schema Snapshot - save and load schema in structured format.
* Source Control - develop database using any VCS.
* SQLDiff - find differences between two states of a databases and generate SQL script to move between these states.
* SQL Search - search of schema objects.
* SQL Editor - enables autocompletion for table aliases.
* SQL Editor - format SQL queries.
* SQL Editor - edit the result of SQL queries.
* SQL Editor - use bind parameters in SQL queries.

*** See also: Valentina Studio Single ($79.99 only) ***

Get Valentina Studio Single as an in-app purchase (pay only once) to get additional advanced pro-features for a single database engine, except for Valentina Project development functionality (reports, forms, JavaScript).

What’s New

Version 11.4.8

Improvements:
[Report Editor] Don't limit barcode data length to 256 characters.
[PostgreSQL] Updated PostgreSQL client library and dump utilities to version 14.

Fixes:
[Report Editor] Fixed updating the report preview, in some cases, it didn't work as expected.
[Report Editor] Fixed applying the best size for the multiline label.
[Report Editor] Labels of EAN-13, UPC-A, UPC-B, ISBN barcodes are generated without the leading digit, GS1 DataBar label is cropped.
[Data Editor][PostgreSQL] Fixed editing values of Timestamp With Timezone columns.

Ratings and Reviews

3.8 out of 5
12 Ratings

12 Ratings

putorel ,

tab cycling

I find it very productive to have the result of a query open up in a new tab; however it will be great if you can provide a combination of keys to be able to cycle through those tabs ( you already have that for the first row of tabs, like when a new sql editor opens up).

also, now that I am here, it would be useful to be enable sql script formatting when creating a view or a function script

Hansaplastique ,

Just as good or even better than the paid-for alternatives

I've been using Valentina Studio for quite a while now, and although not perfect, it most certainly gives the paid-for alternatives a run for their money.
Highly recommend this one!

coruus ,

Amazingly easy to use

Wow, wish I’d found this a long time ago. Been using Workbench and it’s always been a fight. Not so with Valentina. Thanks!

App Privacy

The developer, Paradigma Software, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Linked to You

The following data may be collected but it is not linked to your identity:

  • Identifiers
  • Usage Data

Privacy practices may vary, for example, based on the features you use or your age. Learn More

Supports

  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.