SQL to LogsQL Playground #

• Try it: https://play-sql.victoriametrics.com/

This playground enables you to query data from a VictoriaLogs instance or translate SQL to LogsQL without querying.

What can you do here? #

First, run SHOW TABLES; to view all the existing tables in the SQL database and their equivalent query in LogsQL .

Then, type your SQL query and press Execute.

For example, this query:

      SELECT _time, _msg
FROM logs
WHERE _msg LIKE 'error'
ORDER BY _time DESC
LIMIT 100
    

Translates into:

      _msg:error | fields _time, _msg | sort by (_time desc) | limit 100
    

Distribution #

• GitHub: https://github.com/VictoriaMetrics/sql-to-logsql