
Pooml - Poor Man's Logger
SELECT * FROM logs;
Free2,806 impressions#5 of its week2 comments
Comments
>log in to commentPooml is a self-hosted single-binary log and metrics server using SQLite with a SQL query UI.
- for
- Solo developers and small teams needing lightweight observability for side projects or VPS deployments.
- pricing
- open source
- license
- AGPL-3.0
Key features
- SQL query language — Query logs and metrics directly with standard SELECT, WHERE, GROUP BY etc., no custom DSL.
- FluentBit-compatible ingestion — Accepts logs via HTTP with automatic JSON, CLF or plain text detection and live tail.
- Metrics collection — Push OTLP/HTTP metrics or scrape Prometheus endpoints, supporting counters and gauges.
- Dashboards & charts — Build typed dashboards with stream, chart, and number panels that retain their SQL queries.
- Alerting — Define alerts as SQL queries and deliver via Pushover or Once Campfire with cooldowns.
- Built-in ops — Hourly retention cleanup, S3 backups via SQLite backup API, and self-monitoring metrics.
Use cases
- Debug a recent incident by running a SQL query on recent error logs
- Monitor checkout latency over time with hourly aggregated metrics
- Set up an alert that notifies on high error rates via Pushover
Pooml - Poor Man's Logger FAQ
How do I ingest logs into Pooml?+
Send HTTP POST requests to the ingestion API (default port 8080) with an API key, or configure FluentBit to forward logs.
Can I query logs with AI assistants?+
Yes, the @pooml/mcp package lets Claude or other MCP clients send read-only SQL queries to your instance.
What storage does Pooml use?+
All logs and metrics are stored in three SQLite files on disk, which can be backed up or opened with any SQLite tool.
Is Pooml suitable for high-availability setups?+
No, it runs as a single-node binary with one login secret and does not provide clustering or HA.
How are alerts delivered?+
Alert rules are SQL queries; when they fire, notifications are sent via Pushover or Once Campfire.
What are the resource requirements?+
The binary idles at a few dozen megabytes of RAM and can run on the cheapest VPS instance.
Summarized by DevHunt from pooml.com · Sep 28, 2026. Details may change; check the official site.




-(1).png?auto=compress&fit=max&w=64)

