{"command":{"effect":"read","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Executes an SQL or LQL query on the project's unified logs stream.\n\nEither the `iso_timestamp_start` and `iso_timestamp_end` parameters must be provided.\nIf both are not provided, only the last 1 minute of logs will be queried.\nThe timestamp range must be no more than 24 hours and is rounded to the nearest minute. If the range is more than 24 hours, a validation error will be thrown.\n\nFilter by the `source` column to specify specific log sources, such as edge_logs, postgres_logs, etc.\n\nNote: SQL must be written in **ClickHouse SQL dialect**.\n","properties":{"path":{"type":"object","properties":{"ref":{"minLength":20,"maxLength":20,"pattern":"^[a-z]+$","type":"string","examples":["abcdefghijklmnopqrst"],"description":"Project ref"}},"required":["ref"],"additionalProperties":false},"query":{"type":"object","properties":{"sql":{"type":"string","examples":["select event_message from edge_logs limit 10"],"description":"Custom SQL query to execute on the logs. See [querying logs](https://supabase.com/docs/guides/monitoring-and-debugging/logs#querying-with-the-logs-explorer) for more details."},"iso_timestamp_start":{"format":"date-time","pattern":"^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z))$","type":"string","examples":["2025-03-01T00:00:00Z"]},"iso_timestamp_end":{"format":"date-time","pattern":"^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z))$","type":"string","examples":["2025-03-01T23:59:59Z"]}},"required":[],"additionalProperties":false}},"required":["path"],"additionalProperties":false},"name":"Gets all project's logs in a single log stream","id":"supabase.v1-get-project-logs","example":{"path":{"ref":"abcdefghijklmnopqrst"}},"maxRequests":1,"summary":false}}