---
title: Reference | Tiger Data Docs
description: 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

SQL functions, views, and settings for TimescaleDB, on both Tiger Cloud and self-hosted TimescaleDB. See the [TimescaleDB reference](/reference/timescaledb/index.md) for:

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

## TimescaleDB Toolkit

Advanced analytics hyperfunctions for statistical analysis and time-series workflows. See the [TimescaleDB Toolkit reference](/reference/toolkit/index.md) 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

Everything you need to manage Tiger Cloud services programmatically. See the [Tiger Cloud reference](/reference/tiger-cloud/index.md) for:

- [Data tiering](/reference/tiger-cloud/data-tiering/index.md): SQL functions that move older chunks to low-cost object storage while keeping them queryable.
- [Tiger CLI](/reference/tiger-cloud/tiger-cli/index.md): every Tiger CLI command, configuration parameter, and global flag.
- [Tiger MCP](/reference/tiger-cloud/tiger-mcp/index.md): the Tiger MCP tools and `tiger mcp` commands that let your AI assistant manage Tiger Cloud.
- [Tiger REST API](/reference/tiger-cloud-rest/index.md): create, resize, and configure services over HTTP.