General Highlights

• Diagram Editor – visually design databases and generate tables/objects directly from diagrams
• Schema Editor – create and modify tables, views, fields, enums, links, indexes, triggers, and procedures
• Data Editor – browse and edit records with inline editing, sorting, filters, custom layouts, image previews, and hex editing for binary fields
• Related Data Editor – navigate linked records, link/unlink with a click, and perform set operations across relationships
• SQL Editor – enjoy syntax coloring, auto-completion, reusable queries, templates, and detailed error/warning reporting, search, export results to CVS, JSON, Excel
• Server Administrator – add|drop users, groups, priviledges, watch live logs, run diagnostics, register | unregister databases, create | alter | schedule events

Productivity

• Start Page –create, manage databases, database servers, projects, bookmarks

Use Valentina Reports

• View | Print Reports with parameters locally and Reports registered on Valentina Server

Use Valentina Forms

• Open |  Work with data in Forms stored in a local Project and Forms stored on Valentina Server

Utilities

• Create bookmarks for regularly used connections
• Import MySQL Workbench diagrams
• SQLite diagnose | compact; SQLCipher encrypt | decrypt | modify
• Generate database schema documentation (selected databases)
• Sync settings (bookmarks, etc) with cloud services (Google Cloud, iCloud, Dropbox)

Language Versions

• English
• NEW! French
• German
• NEW! Italian
• NEW! Japanese
• NEW! Korean
• NEW! Polish
• Russian
• Ukrainian

Schema Editor Unleashed

• Forward engineering diagramming –generate scripts for new databases, build from large toolbox of controls (labels, comments, procedures, tables, views), easy navigation of large diagrams
• Schema cache – save to disk, restore, and use next time database is opened
• Schema editor colors – on | off | reset menus, objects and more
• Virtual links in Schema Editor  –unlimited (fk-like) links that do not modify the database

Data Editor Unleashed

• Transactions manager  – make changes to tables; commit or roll back changes as a single unit
• Advanced value formatting  – modify formatting, universal and database specific formats
• Multi-record update  – make changes and set to all records or all filtered records
• Data editor colors – on | off | reset menus, objects and more
• Data editor layouts  – create | delete | manage custom layouts
• Virtual links in Data Editor – unlimited (fk-like) links that do not modify the database
• Direct exports  – CSV, Excel, HTML, JSON, SQL

SQL Editor Unleashed

• Smart Suggestions  – auto-complete anticipates, offers options to avoid unnecessary typing of code
• SQL formatting engines - your choice of sqlparse or SQLglot
• Virtual links in SQL Editor – virtual links supported in SQL editor auto-complete
• NEW! SQL Editor Studio AI– AI Chat with ASK and Agent modes
• NEW! Visual EXPLAIN– Visual EXPLAIN for all databases that support the EXPLAIN statement

Query Editor Unleashed

• Visual Data Sources   – Drag-create tables, links and views
• Edit in SQL Editor   – Edit built queries in SQL Editor and save to Snippets library
• Share Queries  – Copy your generated SQL queries to use in any application
• NEW! Diagram Auto-Update  – Edit Query and auto-update apply changes to diagram
• NEW! Diagram SQL Scripts  – Attach an arbitrary SQL script to a table definition in a diagram

Report Designer

• Reports Toolbox – Drag-create Reports controls, widgets & layouts to create reports visually
• Object Scripting – Script reports objects with JavaScript or Python
• Unlimited Deployment to End Users  – Deploy Reports to end users to open in free Report Viewer¹
• Share with  Reports Server  – Register Reports on Valentina Server for multi-user access
• Deploy with your Xojo App  – Deploy Reports to your desktop app with Valentina Reports ADK engine²
• NEW! Parquet as Data Source – Use Parquet files as data sources for reports

Forms Designer

• Reports Toolbox – Drag-create Form controls, widgets & layouts to create forms visually
• Object Scripting – Script form objects with JavaScript or Python
• Unlimited Deployment to End Users  – Deploy Forms to end users to open in free Forms User¹
• Share with Forms Server  – Register Forms on Valentina Server for multi-user access

Utilities & Power Tools

• Advanced SQL Search  – search with advanced filter dialog, REGEX, property browser, path browser
• Create | Load Dump  – structure, records, structure & records dump for selected databases
• Data Transfer  – copy records between databases, specify mapping, log details, observe transfer and result; NEW! transfer records in batches
• Schema Snapshot  –save database schema in a structured form
• SQLDIFF  –see detailed differences, produce SQL scripts, and apply changes to the database(s)
• Source Control  – commit, evaluate & commit, and migrate database schema
• Workspaces  –  create, delete, modify workspaces that save Bookmarks, SQL Snippets, recent databases, recent projects, open connections, open local databases, Query log

1. Included in Valentina Studio FREE version on Linux, macOS and Windows
2. Requires Valentina Reports ADK for your target platform