Skip to content
Search ⌘K
Get started

Reference

SQL function reference, analytics functions, configuration, and the tools and APIs for managing Tiger Cloud

Complete reference documentation for TimescaleDB, TimescaleDB Toolkit, and Tiger Cloud. Use it to look up exact SQL function signatures, configuration parameters, command syntax, and API endpoints. For step-by-step guidance, see the task-based sections such as Get started, Build, and Deploy.

TimescaleDB

Section titled “TimescaleDB”

SQL functions, views, and settings for TimescaleDB, on both Tiger Cloud and self-hosted TimescaleDB. See the TimescaleDB reference for:

  • Hypertables and chunks: create and manage hypertables and chunks, including size and statistics, tablespaces, reordering, and query optimization.
  • Hypercore: the hypercore columnstore, including columnstore policies, manual conversion, and per-chunk settings.
  • Continuous aggregates: create, modify, and schedule refresh policies for continuous aggregates.
  • Hyperfunctions: time-series utilities, distribution analysis, and gapfilling.
  • Data retention: drop old data on a schedule.
  • Jobs and automation: schedule and manage user-defined actions.
  • UUIDv7 functions: generate and inspect time-ordered UUIDs.
  • Informational views: inspect hypertables, chunks, columnstore settings, jobs, and policies.
  • Configuration: GUCs and PostgreSQL configuration parameters.
  • Administration: administrative functions and commands.

TimescaleDB Toolkit

Section titled “TimescaleDB Toolkit”

Advanced analytics hyperfunctions for statistical analysis and time-series workflows. See the TimescaleDB Toolkit reference for approximate count distinct, statistical and regression analysis, minimum and maximum, financial analysis, percentile approximation, counters and gauges, state tracking, and saturating math.

Tiger Cloud

Section titled “Tiger Cloud”

Everything you need to manage Tiger Cloud services programmatically. See the Tiger Cloud reference for:

  • Data tiering: SQL functions that move older chunks to low-cost object storage while keeping them queryable.
  • Tiger CLI: every Tiger CLI command, configuration parameter, and global flag.
  • Tiger MCP: the Tiger MCP tools and tiger mcp commands that let your AI assistant manage Tiger Cloud.
  • Tiger REST API: create, resize, and configure services over HTTP.