AI Agents for Betterstack

Dynamically load MCP tools for comprehensive BetterStack monitoring and incident management. This ability provides access to advanced BetterStack capabilities including: - Create, update, and manage monitors and alerts - Query monitoring data with complex filters and sorting - Manage incident workflows and on-call schedules - Handle team collaboration and communication - Work with reporting and analytics features Note: Do not call this ability if BetterStack MCP tools are already loaded and available.

Execute a SQL query against BetterStack Logs via the ClickHouse HTTP API. Use this to search, filter, and analyze your log data with powerful SQL queries.

Query recent log entries from BetterStack Logs. **First, check available log retention:** SELECT min(dt) as earliest, max(dt) as latest, count(*) as total FROM remote({TABLE_PREFIX}_logs) FORMAT JSONEachRow **Then query within the available range:** SELECT dt, raw FROM remote({TABLE_PREFIX}_logs) WHERE dt >= now() - INTERVAL 30 MINUTE ORDER BY dt DESC LIMIT 100 FORMAT JSONEachRow Note: Log retention varies by plan. Always verify available time range before querying historical data.

Query historical log entries from BetterStack Logs using S3 cold storage. **Check available historical range:** SELECT min(dt) as earliest, max(dt) as latest, count(*) as total FROM s3Cluster(primary, {TABLE_PREFIX}_s3) WHERE _row_type = 1 FORMAT JSONEachRow **Query historical logs:** SELECT dt, raw FROM s3Cluster(primary, {TABLE_PREFIX}_s3) WHERE _row_type = 1 AND dt >= now() - INTERVAL 24 HOUR ORDER BY dt DESC LIMIT 100 FORMAT JSONEachRow