Tiger Data Workshop | Build Your IoT Database FAST with TimescaleDB

If you're managing sensor data from a factory floor, IoT devices in the field, or any workload generating a continuous stream of timestamped data, this workshop walks through the exact steps to set it up, query it fast, and store it cheap. In this workshop, we cover: • Setting up a Tiger Cloud service and connecting to it • What time-series data is and why Postgres needs help handling it • Hypertables: how TimescaleDB automatically partitions your data into time-based chunks • Hypercore: columnar compression that got us a 6.34x compression ratio (and routinely 90%+ on real-world data) • Writing metadata + history tables the right way (and why you should separate them) • Continuous aggregates: turning a 1.7s query into a ~3ms query • Data retention policies: automatically dropping old chunks • Bonus: connecting the Tiger MCP server to Claude Code so an LLM can query your database for you! 🛠 Resources mentioned in this workshop: 📌 GitHub repo (all SQL + workshop code) ⇒ https://github.com/timescale/tigerdata-devrel-workshops 📌 Try Tiger Cloud for FREE ⇒ https://tsdb.co/td-yt 📌 Docs: chunk sizing / interval formula ⇒ https://www.tigerdata.com/docs/learn/hypertables/sizing-hypertable-chunks 📌 Blog: ingesting data via Python ⇒ https://www.tigerdata.com/blog/when-and-how-to-use-psycopg2 📌 Tiger Data community on Slack: https://tsdb.co/exrnuodf 📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀 ⏱ 00:00 – Welcome & workshop roadmap ⏱ 01:13 – Setting up your Tiger Cloud service ⏱ 03:32 – What is time-series data & why Postgres needs TimescaleDB ⏱ 05:08 – Hypertables explained ⏱ 06:33 – Hypercore & columnar compression explained ⏱ 08:02 – Creating your tables (metadata vs. history) ⏱ 10:01 – Creating the hypertable (parameters walkthrough) ⏱ 21:24 – Generating 15M rows of sample data ⏱ 26:24 – Compression in action ⏱ 30:23 – Querying your data: slow query to continuous aggregate ⏱ 34:30 – Automating data retention ⏱ 35:39 – What you built in this workshop ⏱ 37:40 – Bonus: Tiger MCP server + Claude Code demo ⏱ 39:50 – Wrap-up, free trial credits & next steps Tiger Data is the company behind TimescaleDB, the #1 time-series database. Tiger Cloud is our fully managed Postgres platform built for speed at scale.