Valentina Studio
Valentina Studio is a database management and development tool for SQL and NoSQL workflows. It combines visual schema design, record editing, SQL editing, and query building for databases including PostgreSQL, MySQL/MariaDB, SQLite, MongoDB, and DuckDB.
Valentina Studio helps you design databases, edit records, write queries, and administer database servers. It supports DuckDB, MySQL/MariaDB, MongoDB, Microsoft SQL Server, PostgreSQL, SQLite, and ValentinaDB, and is available for macOS, Windows, and Linux.
The diagram editor lets you design a database visually and generate tables and other objects from the diagram. The schema editor handles tables, views, fields, indexes, triggers, and procedures. For working with data, you can edit records inline, sort by multiple columns, apply filters, preview images, and inspect binary fields with a hex editor. A related-data editor lets you navigate linked records and link or unlink them.
You can write SQL with syntax coloring, auto-completion, reusable queries, and templates, or build queries visually with nested queries and SQL set operations. Server administration tools cover users, groups, privileges, live logs, diagnostics, and scheduled events.
Valentina Studio PRO adds transaction controls for committing or rolling back table changes together, multi-record updates, and virtual links that do not modify the database. It also includes tools for transferring records between databases, comparing schemas and generating SQL change scripts, and saving workspaces with connections, snippets, and query history. Its report and form designers support visual layouts and JavaScript or Python scripting. AI chat integration lets you use an LLM to help build, test, and modify SQL queries and forms.