Design business reports to run in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit. Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE. Backwards Engineering in Standard with Forward Engineering in Valentina Studio Pro.

Valentina Studio is your universal database management tool for working with MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB databases. Valentina Studio lets you connect with all major databases, run queries and generate diagrams to better understand your mission critical business data - and that is the free version of Valentina Studio.

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

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 jаvascript
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

Only for V.I.P