TimescaleDB

Category: SQL, Timeseries Status: good

Connects to a TimescaleDB instance — a PostgreSQL extension optimized for time-series data. Supports full SQL plus time-series specific features.

Connection Settings

Field	Default	Description
host	localhost	Server hostname or IP
port	5432	TCP port
user	(empty)	Database username
password	(empty)	Database password
dbname	(empty)	Database name
url	(empty)	Full connection URL (overrides above fields)

Authentication

Supports three modes: - user_password — standard username + password (default) - secretsmanager — AWS Secrets Manager - aws_iam — AWS IAM token

Supported Actions

• execute — run SQL/TimescaleDB queries
• download / upload — export and import data
• delete — drop tables or hypertables
• backup — create/restore database backups
• liquibase — migration support
• transfer_table — copy table to another connector
• drawing_nodes / dbdiagram — visualize table relationships
• stream_table — stream table data in real time
• python_description / django_description / sqlalchemy_description — generate ORM model code

External Links

• https://docs.timescale.com/