logql v1.0.0

logql v1.0.0

SQL-like query language for structured logs.

Features

• SQL-like syntax: SELECT, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET
• Auto-detect log format: JSON, logfmt, CLF, syslog, CSV, TSV, plain text
• Nested field access: request.method, response.status
• Rich filtering: =, !=, <, >, LIKE, IN, BETWEEN, CONTAINS, MATCHES (regex)
• Aggregations: COUNT, SUM, AVG, MIN, MAX with GROUP BY and HAVING
• Multiple output formats: table, JSON, JSONL, CSV, TSV
• HEAD / TAIL for grabbing first/last N records
• Zero dependencies -- pure Python
• Python API for library usage

Install

pip install logql

Quick Start

cat app.log | logql "SELECT * WHERE level = 'error'"
logql "SELECT level, COUNT(*) FROM 'app.log' GROUP BY level ORDER BY COUNT(*) DESC"

284 tests passing.