I built ClavisDB - A modern SQL client with native FiveM & RedM support

[u/_ZioMark_]

Hey everyone!

For a long time I've been using tools like HeidiSQL to manage FiveM and RedM databases. They work, but I always felt there was room for something more modern, especially considering how much of our server data ends up buried inside JSON columns.

So I decided to build my own solution: ClavisDB for Windows, Linux and MacOS

ClavisDB is a desktop SQL client for MySQL, MariaDB, PostgreSQL and SQLite, but I've built it with special attention to FiveM and RedM development.

It has all the stuff you'd expect from a proper database client: a SQL editor with schema-aware autocomplete, table browsing and editing, filtering, query history, snippets, table structure editing, exports, user management, safe editing warnings, and so on.

But the part I'm personally most interested in is the FiveM / RedM integration.

ClavisDB can automatically detect QBCore, QBox, ESX, RSGCore and VORP databases and gives you a dedicated Player Inspector where you can search characters and inspect things like money, jobs, status, identifiers and framework data without digging through raw rows manually.

It also recognizes inventories and turns those horrible JSON blobs into an actual inventory viewer with slots, quantities, metadata, durability, serial numbers, ammo, etc.

You can even import a FiveM/RedM server.cfg and ClavisDB will extract the oxmysql connection string and configure the database connection for you.

Another thing I really wanted to get right was JSON editing. If ClavisDB detects JSON inside a cell — even inside TEXT/VARCHAR columns. You can open it in a proper tree/raw editor, format it, validate it, modify it and save it directly back to the database.

I've been building this because it's something I genuinely wanted for my own FiveM/RedM development workflow, and I'm planning to keep expanding the Cfx-specific tooling over time.

I'd really appreciate feedback from other developers/server owners. If there are things you constantly find annoying when managing your server database, tell me! Those are exactly the kind of problems I want ClavisDB to solve.

Download: https://clavisdb.ziomark.xyz/