TimescaleDB
Time-series database package built on PostgreSQL/TimescaleDB. Provides connection management, hypertable creation with configurable chunk intervals and data migration, batch data insertion via transactions, time-series querying with time_bucket aggregation, raw SQL execution with parameterized queries, compression with automatic policies, continuous aggregate creation with refresh policies, manual aggregate refresh over time windows, and chunk-based data retention (drop chunks). Authenticates via server/port/database/username/password credentials.
| Namespace | Robomotion.TimescaleDB |
| Version | 1.1.0 |
| Category | Database |
| Nodes | 11 |
Nodes
| Node | Description |
|---|---|
| Connect | Opens a connection to TimescaleDB and returns a Client ID. |
| Disconnect | Closes a TimescaleDB connection. |
| Execute Query | Execute Query — see the properties below. |
| Insert Data | Inserts a data in TimescaleDB. |
| Query Data | Queries a data in TimescaleDB. |
| Create Hypertable | Creates a hypertable in TimescaleDB. |
| Drop Chunks | Drop Chunks — see the properties below. |
| Enable Compression | Enable Compression — see the properties below. |
| Create Continuous Aggregate | Creates a continuous aggregate in TimescaleDB. |
| Refresh Continuous Aggregate | Refreshes a continuous aggregate in TimescaleDB. |
| Toolkit | Exposes this package's operations to an AI Agent as a single tool. |
Connecting
This package has a Connect node. Run it once at the start of your flow; it returns a Client ID that the other nodes take as input. Pair it with Disconnect so the connection is released when the flow ends.
Credentials belong in a Vault rather than typed into the node.
AI Agent tools
10 of these nodes are exposed as tools an AI Agent can call directly:
Connect, Disconnect, Execute Query, Insert Data, Query Data, Create Hypertable, Drop Chunks, Enable Compression, Create Continuous Aggregate, Refresh Continuous Aggregate.
Generated from the package spec that the Flow Designer itself loads, so the node list and every property below match the version above exactly.
It does not yet include worked examples or service-specific guidance — those are written by hand, and a plausible-sounding guess in a reference page is worse than an honest gap. If you build something useful with this package, the community is the place to share it.