TimescaleDB API

TimescaleDB is an open-source PostgreSQL extension that equips your database with time-series features like hypertables, continuous aggregates, and hyperfunctions. Use standard SQL or REST via tools like PostgREST to build scalable analytics pipelines—no extra signup, just install the extension.

1

Endpoints

27

Views

Jul 20, 2025

Last Checked

NaN

Rate Limit

API Endpoints

Executes SQL queries on time-series database

Full URL

http://localhost:5432/query

Code Examples

curl -X POST 'http://localhost:5432/query' \
  -H 'Authorization: Bearer YOUR_API_KEY'

Parameters

{
  "query": "SELECT * FROM cpu_usage WHERE time > NOW() - INTERVAL '1 hour'"
}

Example Response

{
  "results": [
    {
      "host": "server1",
      "time": "2023-07-18T14:00:00Z",
      "usage": 42.5
    }
  ]
}

Version

v2

Rate Limit

100 queries/minute
Tags
databasetime-series
Technical Details
Authentication
None
Response Formats
SQL
Availability
global
Status
Published
Rate Limits

Self-managed

Supported Languages
SQLPython
Use Cases
iot data
financial analytics

Related APIs

Discover similar APIs that might interest you

APIfreemium

Supabase Vector API

Supabase Vector API enables developers t...

Category
Database
Endpoints
1
embeddingsvector-database
APIopen source

Qdrant Vector Search

Qdrant is an open-source vector database...

Category
Database
Endpoints
1
similarity-searchvector-database
APIopen source

NocoDB API

NocoDB auto-generates a powerful REST an...

Category
Database
Endpoints
1
databasespreadsheet