Valentina Studio favicon

Valentina Studio

Valentina Studio is the universal tool for database architects, developers, DBAs and data workers to work with the most popular RDBMS including Valentina DB, MySQL, PostgreSQL, SQLite, and MS SQL Server. It provides visual data modeling with diagrams, development of database schema, managing records, SQL development and querying, server administration, etc. In PRO you can develop a Valentina Project where design Reports and Forms automating them using JavaScript. Under Valentina Server project can be used by many users. FREE Edition brings you powerful, visual editors including:

  • Diagram Editor - design your new db here then generate tables and other db objects from that diagram.
  • Schema Editor (tree view and column view) - create/modify schema objects: Tables, Views, Fields, Enums, Links, Constraints, Triggers, Indexes, Stored Procedures, ...
  • Data Editor - easily browse table records in a grid, modify records, 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 an saved favorite queries, templates, console with error/warning reporting, ...
  • Server Admin - where you can manage users, learn logs and other parameters of servers. PRO Edition adds more tools:
  • Valentina Project - keep here reports, forms, javascripts
  • Form Editor - design forms
  • Report Editor - design reports
  • Query Builder - build SQL queries visually using just a few mouse clicks 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, ... MAS version of Valentina Studio uses iCloud to share bookmarks and recent connections between your devices!