PostHog vs Xata
Open source product analytics — all-in-one dev tool
vs. Serverless Postgres with branching, zero-downtime schema changes + OpenAI embeddings
Pricing tiers
PostHog
Free (generous)
No credit card. Each product has its own free monthly quota. Great for startups + OSS.
Free
Paid (usage-based)
Pay only what you use, after free quotas. Volume discounts at higher tiers. 6 projects, 7-year retention.
$0 base (usage-based)
Self-Hosted (OSS)
MIT-licensed. Run on your own infra via Docker/k8s. Zero vendor lock-in.
$0 base (usage-based)
Enterprise
Custom. SAML SSO, dedicated CSM, custom SLA.
Custom
Xata
Free
$0. 15GB storage. 10 branches. Unlimited databases. Community support.
Free
Pro
$20/mo + usage. More compute, higher concurrency, priority support.
$20/mo
Enterprise
Custom. SSO, dedicated support, VPC peering, SOC 2.
Custom
Free-tier quotas head-to-head
Comparing free on PostHog vs free on Xata.
| Metric | PostHog | Xata |
|---|---|---|
| data warehouse rows | 1000000 rows/month | — |
| error tracking exceptions | 100000 exceptions/month | — |
| feature flags requests | 1000000 requests/month | — |
| llm analytics events | 100000 events/month | — |
| logs gb | 50 GB/month | — |
| product analytics events | 1000000 events/month | — |
| projects | 1 projects | — |
| retention years | 1 year | — |
| session replay recordings | 5000 recordings/month | — |
| surveys responses | 1500 responses/month | — |
| team members | unlimited members | — |
Features
PostHog · 14 features
- A/B Testing — Experiments with significance analysis.
- Data Pipelines — Export events to BigQuery, Snowflake, S3.
- Data Warehouse — Query external sources (Stripe, Hubspot, S3) alongside events with SQL.
- Error Tracking — Sentry-style error tracking in same platform.
- Feature Flags — Rollout flags with targeting, A/B testing, JSON payloads.
- LLM Analytics — Tracing + cost tracking for OpenAI, Anthropic, Gemini, etc.
- Logs — Centralized log ingest with free 50 GB/month.
- Product Analytics — Events, funnels, trends, retention, paths. SQL insights available.
- Revenue Tracking — Integration with Stripe for revenue + churn metrics.
- Self-Hosting — Docker/Helm. Full feature parity with cloud.
- Session Replay — Watch user sessions. Privacy controls, masked inputs, JS errors.
- SQL Query API — Run ClickHouse SQL over your events via API.
- Surveys — In-app surveys + feedback widgets.
- Workflows — Trigger emails/webhooks on events.
Xata · 11 features
- Ask Xata (OpenAI) — Natural language Q&A over data.
- Branching — Copy-on-write DB branches.
- DB Metrics — Query perf + connection metrics.
- Migration GUI — Visual schema change workflow.
- pgroll Migrations — Zero-downtime schema evolution via views.
- PITR Backups — Point-in-time restore.
- PR Preview Environments — Branch-per-PR with CI integration.
- Search — Built-in full-text search indexing.
- Vanilla Postgres — Unmodified Postgres 15+.
- Vector Search — pgvector-based embeddings + Q&A.
- Xata Copilot — AI SQL + schema assistant.
Developer interfaces
| Kind | PostHog | Xata |
|---|---|---|
| CLI | — | pgroll CLI (OSS), xata CLI |
| SDK | posthog-android, posthog-flutter, posthog-go, posthog-ios (Swift), posthog-js, posthog-node, posthog-php, posthog-python, posthog-react-native, posthog-ruby | @xata.io/client (TS), xata (Python) |
| REST | PostHog REST API | Xata REST API |
| MCP | PostHog MCP | — |
| OTHER | Webhooks + Actions | Direct Postgres (pgroll), Xata Dashboard |
Staxly is an independent catalog of developer platforms. Outbound links to PostHog and Xata are plain references to their official websites. Pricing is verified against vendor pages at publication time — reconfirm before buying.
Want this comparison in your AI agent's context? Install the free Staxly MCP server.