> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# TimescaleDB API Reference

> Complete API reference for TimescaleDB functions, SQL commands, and time-series data management

export const HYPERFUNC_CAP = 'Hyperfunctions';

export const HYPERTABLE_CAP = 'Hypertable';

export const TIMESCALE_DB = 'TimescaleDB';

export const HYPERFUNC = 'hyperfunctions';

<CardGroup cols={2}>
  <Card title="Hypertables and chunks" icon="table" href="/api-reference/timescaledb/hypertables/index">
    Create and manage hypertables, chunks, dimensions, and indexes for time-series data
  </Card>

  <Card title="Hypercore" icon="database" href="/api-reference/timescaledb/hypercore/index">
    Manage columnstore tables for analytical workloads with hybrid row and column storage
  </Card>

  <Card title="Continuous aggregates" icon="chart-simple" href="/api-reference/timescaledb/continuous-aggregates/index">
    Create and manage automatically refreshed materialized views for time-series data
  </Card>

  <Card title="Hyperfunctions" icon="function" href="/api-reference/timescaledb/hyperfunctions/index">
    Analyze time-series data with time bucketing, gapfilling, and distribution analysis
  </Card>

  <Card title="Data retention" icon="clock-rotate-left" href="/api-reference/timescaledb/data-retention/index">
    Automatically drop old data with retention policies
  </Card>

  <Card title="Jobs and automation" icon="robot" href="/api-reference/timescaledb/jobs-automation/index">
    Schedule and manage automated background jobs
  </Card>

  <Card title="UUIDv7 functions" icon="fingerprint" href="/api-reference/timescaledb/uuid-functions/index">
    Generate and manipulate UUIDv7 identifiers with built-in timestamp ordering
  </Card>

  <Card title="Informational views" icon="eye" href="/api-reference/timescaledb/informational-views/index">
    Query metadata about hypertables, chunks, jobs, and system configuration
  </Card>

  <Card title="Configuration" icon="gear" href="/api-reference/timescaledb/configuration/index">
    Configure TimescaleDB settings and parameters
  </Card>

  <Card title="Administration" icon="screwdriver-wrench" href="/api-reference/timescaledb/administration/index">
    Administrative functions for backup, restore, and system management
  </Card>
</CardGroup>

{TIMESCALE_DB} provides SQL commands and functions for managing time-series data efficiently. For additional
{HYPERFUNC}s for advanced time-series analysis, see the [TimescaleDB Toolkit API reference][tookit-api-ref].

[tookit-api-ref]: /api-reference/timescaledb-toolkit