• The Best Free DB Management Tool

    Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.

  • Powerful Reports Editor

    Design business reports to run in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit.

  • Visual Data Modeling for Free

    Backwards Engineering in Standard with Forward Engineering in Valentina Studio Pro.

  • On Your OS

    Linux, Windows & Mac OS X for Desktop. Free iValentina for iPhone & iPad.
› ‹
  • 1
  • 2
  • 3
  • 4
  • Valentina Studio Key Features
  • Valentina Studio Pro Key Features
  • Valentina Studio System Requirements

Free Valentina Studio Features & Benefits At a Glance

See a list of Valentina Studio key features...

Schema Editing & Diagramming
  • Manage multiple databases in tabs and dockable views
  • Create/Drop/Alter/Browse Tables, Fields, Indexes, Triggers, Constraints, Links, Views, Stored Procedures, Properties, Sequences, Types, ...
  • Edit properties of multiple objects at the same time
  • Drill down to tables and fields; incredible fast searching
  • Reverse engineering and create diagrams for existing databases. Add new objects to diagrams.
Server Administration
  • Add/drop users, groups, manage privileges
  • Watch live logs, run diagnostics
  • Remotely Register/unregister databases
  • Create/Alter Schedule events
Valentina Reports
  • View Reports with parameters stored locally and registered on Valentina Server
  • Print Reports with parameters stored locally and registered on Valentina Server
  • Reports Designer available in Valentina Studio Pro
Valentina Forms
  • Use local Valentina Forms to work with your data
  • Access Valentina Forms in projects registered on Valentina Server
  • Forms Designer available in Valentina Studio Pro
SQL Editing
  • Write SQL queries with auto-completion, color syntax
  • Define, manage, save favorite queries; access recent queries
  • Function browser dictionary of each function
  • Consoles for errors, warnings, performance
  • Search, Export result records into CSV, JSON, Excel
Utilities
  • Diagnose, compress, clone, defragment, reindex and dump data
 

Valentina Studio Pro Features & Benefits At a Glance

See a list of Valentina Studio Pro key features...

Report Designer
  • Visual design layout tools turn queries into reports; live preview
  • Toolbox of controls, html, barcodes, charts, graphs and more
  • Sub-reports, regions, groups
  • Easy add macros, expressions
  • Print to all standard paper formats, set gutter, margin, max records per page
  • Deploy Report projects for Valentina Reports ADK applications
  • Deploy Report projects to Valentina Server
Forward Engineering
  • Visual Diagram Editor generates new databases
  • Toolbox of controls, labels, comments, procedures, tables, views
  • Generate scripts, copy scripts into your app code
  • Easy visual navigation of very large diagrams
Database Continuous Integration
  • Create | Save | Load database schema snapshots in structured format
  • Register | Commit | Increment database source control with any VCS
  • Generate Migrate scripts
Forms Editor
  • Drag-create controls, widgets & layouts to create forms visually
  • Attach and write custom methods in JavaScript
  • Forms work work with any supported datasource including PostgreSQL, MySQL, MS SQL Server, SQLite and ValentinaDB
  • Upload Forms to Valentina Projects on Valentina Server
  • Deploy forms through free Valentina Studio on Windows, MacOS and Linux
Query Builder
  • Build SQL queries with just a few clicks and no code writing
  • Edit built queries in Data Editor and save to Snippets library
  • Copy your SQL queries to use in any application
SQL DIFF
  • See all the details of differences in Tables, Links and more
  • Generate scripts to execute to modify databases
Data Transfer
  • Copy records between two different databases
  • Specify mapping of source/target Tables and Fields
  • Log details and observe the transfer and result
 

These are the Valentina Studio System Requirements for Valentina Studio 9 or later.

Windows
  • Win Vista SP2+;
    Win 7 SP1+; Windows 8; Windows 10
  • HD 20 MB+; RAM 50 MB
    (dependent on database size)
Linux
  • Studio 9.6 (Ubuntu 12.04), Server 9.6.2+(Ubuntu 16.04); Fedora 18+, CentOS 6+, OpenSuse 12+ ,
    glibc >= 2.11; libstdc++6 >= 4.6.0
  • HD 210 MB+; RAM 256 MB
    (dependent on database size)
macOS
  • Studio 9.6 (macOS 10.7+ Intel); Studio 9.6.2+ (macOS 10.12+ Intel)
  • HD 210 MB+; RAM 256 MB
    (dependent on database size)
 

The amount of RAM you have available for databases will directly affect performance of large, in-memory databases.