vSQLMySQL / MariaDB for FiveM

The database resource I wanted for my own servers - a real connection pool, result caching, migrations, a live profiler, deadlock-safe transactions, and MariaDB tuning that uses the features MariaDB gives you. A drop-in successor to oxmysql.

Get started

Install

Recipes

GitHub

Two API styles

Every export takes a callback or returns a Promise - use whichever reads better at the call site. From JS you don't need a wrapper at all.

Parameters that stay safe

Positional ? and named @name / :name, with automatic IN (?) expansion. Always bound by the driver, never interpolated - injection-safe by construction.

Caching where it helps

Prepared-statement caching plus an optional TTL + LRU result cache. Writes invalidate it for you; clear targeted entries with cacheClear(pattern).

Migrations built in

Checksum-validated, lock-protected, dry-run capable, with up / down support - found and applied on start, or driven from the vsql console command.

A profiler you'll check

Latency percentiles, a slow-query log, per-resource attribution, and pg_stat_statements-style query-shape ranking via vsql top.

MariaDB-aware

utf8mb4 defaults, session + statement timeouts, and RETURNING detection with a clean MySQL fallback. The server type is auto-detected on connect.

Resilient by default

Auto-reconnect with backoff; queries made during startup or a reconnect wait on whenReady() instead of failing. Transactions retry on deadlock.

Drop-in compatible

Flip vsql_compat to claim the oxmysql / ghmattimysql / mysql-async export namespaces, and existing scripts route into vSQL with no edits.

Fast where it counts

A memoised per-query binding plan makes parameter binding ~9x faster than oxmysql on reused queries - which is the common case in a running server.