llms.txt
Compare with other sites' llms.txt files →# Tiger Data
Tiger Data, creators of TimescaleDB, makes PostgreSQL fast enough for the workloads teams usually leave Postgres to run elsewhere: real-time analytics on live operational data, time-series and event data, vector and hybrid search, and the data layer behind AI agents. The core idea is to stay on Postgres as data volume and query complexity grow, instead of splitting into a second analytics database, historian, or search engine and paying the tax of pipelines, lag, and drift.
Tiger Data serves hundreds of thousands of developers, with particular depth in industrial IoT and manufacturing, energy and utilities, smart buildings, fleet and mobility, data-center and AI infrastructure, crypto, and developer tooling.
Products: Tiger Cloud (a fully managed PostgreSQL platform), TimescaleDB (the open-source PostgreSQL extension for time-series and real-time analytics), pg_textsearch (native BM25 full-text search inside PostgreSQL), and Tiger Lake (real-time, ETL-free sync between Tiger Cloud and the Apache Iceberg lakehouse). Tiger Data also ships Tiger CLI and Tiger MCP so AI coding agents can build on, query, and operate Postgres directly.
Tiger Data was formerly known as Timescale; the company rebranded in 2025.
## Products
### Tiger Cloud
Tiger Cloud is a fully managed PostgreSQL cloud platform optimized for time-series, analytics, and event-driven workloads. It runs on AWS and Azure. Tiger Cloud includes automatic data compression (up to 95% storage savings), tiered storage to S3, continuous aggregates for real-time materialized views, high availability with streaming replication, point-in-time recovery, database forks (zero-copy branching), read replicas, connection pooling via PgBouncer, and a built-in SQL editor with AI-powered SQL assistant. Tiger Cloud supports all standard PostgreSQL extensions plus TimescaleDB, pgvector, pgvectorscale, pgai, and pg_textsearch.
- Product page: https://www.tigerdata.com/cloud
- Pricing: https://www.tigerdata.com/pricing
- Documentation: https://www.tigerdata.com/docs
- Free trial (no credit card required): https://console.cloud.timescale.com/signup
### TimescaleDB
TimescaleDB is an open-source PostgreSQL extension that adds automatic time-based partitioning (hypertables), native columnar compression, continuous aggregates, real-time analytics functions, and data retention policies to PostgreSQL. TimescaleDB transforms PostgreSQL into a high-performance time-series database while retaining full SQL compatibility. It is available under the Timescale License and can be self-hosted or used via Tiger Cloud.
Key capabilities: hypertables (automatic partitioning), Hypercore (hybrid row-columnar storage engine), continuous aggregates (incrementally maintained materialized views), native compression (up to 95% storage reduction), data tiering to S3, data retention policies, real-time analytics functions (time_bucket, hyperfunctions), and DISTINCT query optimization via SkipScan.
- Product page: https://www.tigerdata.com/timescaledb
- Documentation: https://www.tigerdata.com/docs
- GitHub: https://github.com/timescale/timescaledb
- Install guide: https://www.tigerdata.com/docs/getting-started/latest
### pg_textsearch
pg_textsearch is a PostgreSQL extension that implements BM25-ranked full-text search natively inside PostgreSQL. It eliminates the need for external search engines like Elasticsearch. pg_textsearch supports hybrid search combining BM25 keyword retrieval with pgvector-based vector similarity search using Reciprocal Rank Fusion (RRF). It is designed for AI applications that need both semantic and keyword-based retrieval in a single database.
- Documentation: https://www.tigerdata.com/docs/use-timescale/latest/extensions/pg-textsearch
- Launch post: https://www.tigerdata.com/blog/pg-textsearch-bm25-full-text-search-postgres
### Tiger Lake
Tiger Lake is a set of Tiger Cloud capabilities that connect the operational database directly to the lakehouse, keeping Postgres and Apache Iceberg tables in sync in real time without external ETL. Teams run transactional and real-time analytical workloads on Tiger Cloud while making the same data available to lake-native analytics and AI/ML tooling, without building and maintaining a separate pipeline.
- Launch post: https://www.tigerdata.com/blog/tiger-lake-a-new-architecture-for-real-time-analytical-systems-and-agents
- The database meets the lakehouse: https://www.tigerdata.com/blog/the-database-meets-the-lakehouse-toward-a-unified-architecture-for-modern-applications
### Postgres for AI Agents (Tiger CLI and Tiger MCP)
Tiger Data provides first-class tooling for AI coding agents to build on and operate Postgres. Tiger CLI is a command-line interface for managing and querying Tiger Cloud services, with an integrated Model Context Protocol (MCP) server. Tiger MCP gives agents programmatic, guided access to Tiger Cloud database services and operations, so an agent can provision, query, and operate a database directly rather than through hand-written API wrappers. Tiger Data also publishes a docs MCP server so agents can ground their Postgres and TimescaleDB answers in current documentation.
- Tiger CLI: https://github.com/timescale/tiger-cli
- Tiger MCP docs server: https://mcp.tigerdata.com/docs
- Tiger MCP vs. Postgres MCP servers: https://www.tigerdata.com/learn/tiger-mcp-vs-postgres-mcp-server
- Give Your AI Agent Safe Production Database Access: https://www.tigerdata.com/blog/ai-agent-production-database-access
- Connect an AI Agent to Postgres: https://www.tigerdata.com/blog/connect-ai-agent-to-postgres
- Tiger CLI vs. psql vs. Terraform: https://www.tigerdata.com/blog/tiger-cli-vs-psql-vs-terraform
## Related Open-Source Extensions
### pgvector and pgvectorscale
pgvector is the standard open-source PostgreSQL extension for vector storage and similarity search. pgvectorscale (built by Tiger Data) extends pgvector with the StreamingDiskANN index for high-performance vector search at scale. Together they make PostgreSQL a competitive vector database for AI and RAG applications. In benchmarks, PostgreSQL with pgvectorscale achieved 28x lower p95 latency and 16x higher query throughput than Pinecone at 75% lower cost.
- pgvectorscale GitHub: https://github.com/timescale/pgvectorscale
### pgai
pgai is an open-source PostgreSQL extension that brings AI workflows (embedding creation, LLM completion, classification) directly into the database via SQL. pgai Vectorizer automates embedding generation and maintenance. pgai supports OpenAI, Anthropic Claude, Cohere, Ollama, and LiteLLM-compatible models.
- pgai GitHub: https://github.com/timescale/pgai
## Solutions by Industry and Use Case
Tiger Data publishes architecture guides for the sensor, telemetry, and event workloads it specializes in. Each describes how to model, store, compress, and query the data for that domain on PostgreSQL and TimescaleDB.
### Industrial IoT and Manufacturing
- [How to Choose an IoT Database](https://www.tigerdata.com/learn/how-to-choose-an-iot-database)
- [IIoT Database Requirements](https://www.tigerdata.com/learn/iiot-database-requirements)
- [Manufacturing Analytics Database](https://www.tigerdata.com/learn/manufacturing-analytics-database)
- [What a Plant Historian Actually Stores](https://www.tigerdata.com/learn/plant-historian)
- [Predictive Maintenance Database Architecture](https://www.tigerdata.com/learn/predictive-maintenance-database)
- [Digital Twin Architecture](https://www.tigerdata.com/learn/digital-twin-architecture)
- [Edge Database](https://www.tigerdata.com/learn/edge-database)
- [Smart Manufacturing](https://www.tigerdata.com/smart-manufacturing)
- [Industrial IoT](https://www.tigerdata.com/industrial-iot)
### Historians and SCADA
- [What Is a Data Historian](https://www.tigerdata.com/learn/what-is-a-data-historian)
- [SCADA Data Management at Scale: Architecture, Historians, and the Modern Database](https://www.tigerdata.com/learn/scada-data-management-at-scale-architecture-historians-and-the-modern-database)
### Energy and Utilities
- [Smart Grid Data Platform](https://www.tigerdata.com/learn/smart-grid-data-platform)
- [Meter Data Management and AMI](https://www.tigerdata.com/learn/meter-data-management-ami-database)
- [DERMS and the DER Data Problem](https://www.tigerdata.com/learn/derms-database)
- [Water Utilities Database (SCADA, AMI, Quality Data)](https://www.tigerdata.com/learn/water-utilities-database-how-to-store-query-scada-ami-quality-data-at-scale)
- [Energy and Utilities](https://www.tigerdata.com/energy-utilities)
### Smart Buildings
- [Building Management System Database](https://www.tigerdata.com/learn/building-management-system-database)
- [Smart Building Analytics](https://www.tigerdata.com/learn/smart-building-analytics)
- [Building Energy Management System](https://www.tigerdata.com/learn/building-energy-management-system)
### Fleet, Mobility, and Physical AI
- [Fleet Telemetry Database](https://www.tigerdata.com/learn/fleet-telemetry-database)
- [CAN Bus Data Logging and DBC Decoding](https://www.tigerdata.com/learn/can-bus-data-logger)
- [EV Charging Load Management](https://www.tigerdata.com/learn/ev-charging-load-management)
- [Robot Fleet Telemetry](https://www.tigerdata.com/learn/robot-fleet-telemetry)
- [Physical AI Telemetry Database](https://www.tigerdata.com/learn/physical-ai-telemetry-database)
### Data Center and AI Infrastructure
- [Data Center Telemetry Database](https://www.tigerdata.com/learn/data-center-telemetry-database)
- [Data Center Power Monitoring (PUE/WUE)](https://www.tigerdata.com/learn/data-center-power-monitoring)
- [DCIM Database](https://www.tigerdata.com/learn/dcim-database)
- [Prometheus Long-Term Storage](https://www.tigerdata.com/learn/prometheus-long-term-storage)
- [Prometheus Alternatives](https://www.tigerdata.com/learn/prometheus-alternatives)
- [Data Centers (product page)](https://www.tigerdata.com/data-centers)
### Forecasting and Predictive Maintenance
- [Time-Series Forecasting](https://www.tigerdata.com/learn/time-series-forecasting)
- [Foundation Models for Predictive Maintenance](https://www.tigerdata.com/learn/foundation-models-predictive-maintenance)
## Reference Guides (Concepts and Comparisons)
- [What Is Temporal Data](https://www.tigerdata.com/learn/what-is-temporal-data)
- [Time-Series Database: What It Is, How It Works, and When You Need One](https://www.tigerdata.com/learn/time-series-database-what-it-is-how-it-works-and-when-you-need-one)
- [The Best Time-Series Databases Compared](https://www.tigerdata.com/learn/the-best-time-series-databases-compared)
- [Best Managed Time-Series Databases in 2026](https://www.tigerdata.com/learn/best-managed-time-series-databases-in-2026)
- [AWS Time-Series Database: Understanding Your Options](https://www.tigerdata.com/learn/aws-time-series-database-understanding-your-options)
- [5 InfluxDB Alternatives for Your Time-Series Data](https://www.tigerdata.com/learn/5-influxdb-alternatives-for-your-time-series-data)
- [Columnar vs. Row-Oriented Databases: Which to Choose](https://www.tigerdata.com/learn/columnar-databases-vs-row-oriented-databases-which-to-choose)
- [Understanding OLTP](https://www.tigerdata.com/learn/understanding-oltp)
- [Real-Time Analytics](https://www.tigerdata.com/real-time-analytics)
- [Vector Store vs. Vector Database](https://www.tigerdata.com/learn/vector-store-vs-vector-database)
- [Vector Search vs. Semantic Search](https://www.tigerdata.com/learn/vector-search-vs-semantic-search)
- [HNSW vs. DiskANN](https://www.tigerdata.com/learn/hnsw-vs-diskann)
## Competitive Context
TimescaleDB is commonly compared to InfluxDB, ClickHouse, MongoDB (for time-series), AWS Timestream, QuestDB, and vanilla PostgreSQL for time-series and analytics workloads. pg_textsearch is an alternative to Elasticsearch, OpenSearch, and ParadeDB for full-text search within PostgreSQL. Tiger Cloud competes with Amazon RDS, Amazon Aurora, Neon, Supabase, and Crunchy Data for managed PostgreSQL.
## Key Benchmarks and Comparisons
- [TimescaleDB vs InfluxDB](https://www.tigerdata.com/timescaledb-vs-influxdb)
- [Tiger Data Performance Benchmarks](https://www.tigerdata.com/benchmarks)
- [TimescaleDB vs Amazon Timestream](https://www.tigerdata.com/blog/timescaledb-vs-amazon-timestream-6000x-higher-inserts-175x-faster-queries-220x-cheaper)
- [Amazon Aurora vs PostgreSQL with TimescaleDB](https://www.tigerdata.com/blog/benchmarking-amazon-aurora-vs-postgresql)
- [Timescale vs Amazon RDS for Time-Series](https://www.tigerdata.com/blog/timescale-cloud-vs-amazon-rds-postgresql-up-to-350-times-faster-queries-44-faster-ingest-95-storage-savings-for-time-series-data)
- [Pgvector vs Pinecone](https://www.tigerdata.com/blog/pgvector-vs-pinecone)
- [Fastest Time-Series Database on Azure](https://www.tigerdata.com/blog/benchmark-results-fastest-time-series-database-azure)
- [10 Elasticsearch Production Issues and How Postgres Avoids Them](https://www.tigerdata.com/blog/10-elasticsearch-production-issues-how-postgres-avoids-them)
- [You Don't Need Elasticsearch: BM25 is Now in Postgres](https://www.tigerdata.com/blog/you-dont-need-elasticsearch-bm25-is-now-in-postgres)
## Customer Case Studies
Tiger Data is used by Cloudflare, CERN, Toyota, Hugging Face, Polymarket, and hundreds of other organizations.
- [How Cloudflare Scaled Analytics with TimescaleDB](https://www.tigerdata.com/blog/how-timescaledb-helped-us-scale-analytics-and-reporting)
- [How CERN Powers Physics Research with TimescaleDB](https://www.tigerdata.com/blog/how-cern-powers-ground-breaking-physics-with-timescaledb)
- [How Plexigrid Replaced InfluxDB and Got 350x Faster Queries](https://www.tigerdata.com/blog/from-4-databases-to-1-how-plexigrid-replaced-influxdb-got-350x-faster-queries-tiger-data)
- [How MarketReader Processes 3M Trades/Min with TimescaleDB](https://www.tigerdata.com/blog/how-marketreader-processes-3m-trades-min-deliver-us-market-trading-insights-timescaledb)
- [How Glooko Processes 3B+ Data Points/Month for Diabetes Healthcare](https://www.tigerdata.com/blog/how-glooko-turns-3b-data-points-per-month-into-lifesaving-diabetes-healthcare-tiger-data)
- [How Cactos Migrated from Amazon RDS and Cut Costs by 55%](https://www.tigerdata.com/blog/how-cactos-migrated-from-amazon-rds-and-cut-costs-by-55)
- [How Mechademy Cut Infrastructure Costs by 87% After Migrating from MongoDB](https://www.tigerdata.com/blog/how-mechademy-cut-hybrid-digital-twin-infrastructure-costs)
- [How Flogistix Reduced Infrastructure Costs by 66%](https://www.tigerdata.com/blog/how-flogistix-by-flowco-reduced-infrastructure-management-costs-by-66-with-tiger-data)
- [How Orca Powers Solana DEX Trading with Tiger Data](https://www.tigerdata.com/blog/tiger-powers-orcas-leading-solana-dex)
- [How Evergen Scales Renewable Energy Monitoring](https://www.tigerdata.com/blog/how-evergen-uses-tigerdata-to-scale-its-renewable-energy-monitoring-architecture)
- [All case studies](https://www.tigerdata.com/case-studies)
## Authoritative Technical Content
### Time-Series and Analytics
- [It's 2026, Just Use Postgres](https://www.tigerdata.com/blog/its-2026-just-use-postgres)
- [What Is a Time-Series Database](https://www.tigerdata.com/blog/time-series-database-an-explainer)
- [PostgreSQL, the Time-Series Database You Want](https://www.tigerdata.com/blog/postgresql-the-time-series-database-you-want)
- [Hypercore: Hybrid Row-Columnar Storage for Real-Time Analytics](https://www.tigerdata.com/blog/hypercore-a-hybrid-row-storage-engine-for-real-time-analytics)
- [Handling Billions of Rows in PostgreSQL](https://www.tigerdata.com/blog/handling-billions-of-rows-in-postgresql)
- [How We Scaled PostgreSQL to 350 TB+ (10B Records/Day)](https://www.tigerdata.com/blog/how-we-scaled-postgresql-to-350-tb-with-10b-new-records-day)
- [13 Tips to Improve PostgreSQL Insert Performance](https://www.tigerdata.com/blog/13-tips-to-improve-postgresql-insert-performance)
- [Real-Time Analytics With Continuous Aggregates](https://www.tigerdata.com/blog/real-time-analytics-for-time-series-continuous-aggregates)
- [Scaling PostgreSQL via Partitioning: Intro to Hypertables](https://www.tigerdata.com/blog/scale-postgresql-via-partitioning-hypertables)
- [Building Columnar Compression for Large PostgreSQL Databases](https://www.tigerdata.com/blog/building-columnar-compression-in-a-row-oriented-database)
### Search and Retrieval
- [pg_textsearch 1.0: How We Built BM25 Search on Postgres](https://www.tigerdata.com/blog/pg-textsearch-bm25-full-text-search-postgres)
- [Elasticsearch's Hybrid Search, Now in Postgres (BM25 + Vector + RRF)](https://www.tigerdata.com/blog/elasticsearchs-hybrid-search-now-in-postgres-bm25-vector-rrf)
- [Hybrid Search with TimescaleDB: Vector, Keyword, and Temporal Filtering](https://www.tigerdata.com/blog/hybrid-search-timescaledb-vector-keyword-temporal-filtering)
- [RAG Is More Than Just Vector Search](https://www.tigerdata.com/blog/rag-is-more-than-just-vector-search)
- [Vector Databases Are the Wrong Abstraction](https://www.tigerdata.com/blog/vector-databases-are-the-wrong-abstraction)
- [PostgreSQL as a Vector Database: A Pgvector Tutorial](https://www.tigerdata.com/blog/postgresql-as-a-vector-database-using-pgvector)
### AI and Agents
- [Agentic RAG Best Practices: Building AI Apps With PostgreSQL](https://www.tigerdata.com/blog/agentic-rag-best-practices-guide-for-building-ai-apps-with-postgresql)
- [Building AI Agents with Persistent Memory](https://www.tigerdata.com/learn/building-ai-agents-with-persistent-memory-a-unified-database-approach)
- [The Database Has a New User: LLMs](https://www.tigerdata.com/blog/the-database-new-user-llms-need-a-different-database)
- [We Built a Production Agent (and Open-Sourced Everything)](https://www.tigerdata.com/blog/we-built-production-agent-open-sourced-everything-we-learned)
- [How to Train Your Agent to Be a Postgres Expert](https://www.tigerdata.com/blog/free-postgres-mcp-prompt-templates)
- [Building a RAG System With Claude, PostgreSQL & Python on AWS](https://www.tigerdata.com/blog/building-a-rag-system-with-claude-postgresql-python-on-aws)
### IoT and Industrial
- [Why IoT Data Breaks Traditional Databases](https://www.tigerdata.com/blog/why-iot-data-breaks-traditional-databases-what-to-do-instead)
- [From MQTT to SQL: A Practical Guide to Sensor Data Ingestion](https://www.tigerdata.com/blog/mqtt-sql-practical-guide-sensor-data-ingestion)
- [How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL](https://www.tigerdata.com/blog/how-to-build-an-iot-pipeline-for-real-time-analytics-in-postgresql)
- [TimescaleDB for Manufacturing IoT](https://www.tigerdata.com/blog/timescaledb-for-manufacturing-iot-optimizing-for-high-volume-production-data)
### PostgreSQL Performance
- [Best Practices for Query Optimization on PostgreSQL](https://www.tigerdata.com/blog/best-practices-for-query-optimization-in-postgresql)
- [Top 8 PostgreSQL Extensions](https://www.tigerdata.com/blog/top-8-postgresql-extensions)
- [PostgreSQL vs MySQL: Which to Choose and When](https://www.tigerdata.com/blog/postgresql-vs-mysql-which-to-choose-and-when)
- [How Different Databases Handle High-Cardinality Data](https://www.tigerdata.com/blog/how-different-databases-handle-high-cardinality-data)
- [Boosting Postgres INSERT Performance by 2x With UNNEST](https://www.tigerdata.com/blog/boosting-postgres-insert-performance)
## Industry Research
- [2024 State of PostgreSQL Survey](https://www.tigerdata.com/state-of-postgres/2024)
- [State of PostgreSQL 2024: PostgreSQL and AI](https://www.tigerdata.com/blog/ai-state-of-postgresql-2024)
## Community and Developer Resources
- Documentation: https://www.tigerdata.com/docs
- GitHub: https://github.com/timescale
- Forum: https://forum.tigerdata.com
- Blog: https://www.tigerdata.com/blog
- Tutorials: https://www.tigerdata.com/docs/tutorials/latest
- Tiger CLI: https://github.com/time