Timescaledb
Timescaledb enables efficient time-series data storage and querying for applications needing historical trend analysis and performance monitoring.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add troykelly-timescaledb npx -- -y @trustedskills/troykelly-timescaledb
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"troykelly-timescaledb": {
"command": "npx",
"args": [
"-y",
"@trustedskills/troykelly-timescaledb"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides access to TimescaleDB, a time-series database built on PostgreSQL. It allows AI agents to query and analyze large volumes of timestamped data efficiently, perform aggregations over time intervals, and leverage specialized functions for time series analysis. The skill enables complex queries and visualizations that are difficult or impossible with standard relational databases.
When to use it
- Analyzing sensor data: Process readings from IoT devices or environmental sensors stored in TimescaleDB.
- Financial modeling: Perform calculations and generate reports based on historical stock prices or transaction data.
- Monitoring system performance: Track metrics like CPU usage, memory consumption, or network traffic over time to identify trends and anomalies.
- Building dashboards: Generate visualizations and interactive dashboards displaying time-series data for real-time monitoring.
Key capabilities
- Querying TimescaleDB databases using SQL.
- Performing aggregations (e.g., averages, sums) over specified time intervals.
- Leveraging TimescaleDB's specialized time series functions.
- Data visualization and reporting.
Example prompts
- "Show me the average CPU usage for the last 24 hours."
- "What was the peak temperature recorded yesterday?"
- "Generate a graph of website traffic over the past week."
- “Find all transactions greater than $100 that occurred between January and March.”
Tips & gotchas
- Requires access to a TimescaleDB database. Ensure your AI agent has the necessary credentials and connection details configured.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.