{"command":{"effect":"write","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Execute a SQL query against a D1 database and return results as objects.","properties":{"path":{"type":"object","properties":{"account_id":{"$ref":"#/definitions/d1_account-identifier"},"database_id":{"$ref":"#/definitions/d1_database-identifier"}},"required":["account_id","database_id"],"additionalProperties":false},"body":{"$ref":"#/definitions/d1_batch-query"}},"required":["path","body"],"additionalProperties":false,"definitions":{"d1_account-identifier":{"description":"Account identifier tag.","type":"string","maxLength":32,"examples":["023e105f4ecef8ad9ca31a8372d0c353"]},"d1_database-identifier":{"description":"D1 database identifier (UUID).","type":"string","examples":["xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"]},"d1_batch-query":{"description":"A single query object or a batch query object","oneOf":[{"$ref":"#/definitions/d1_single-query"},{"properties":{"batch":{"type":"array","items":{"$ref":"#/definitions/d1_single-query"}}},"required":["batch"],"title":"multiple queries","type":"object"}]},"d1_single-query":{"description":"A single query with or without parameters","type":"object","properties":{"params":{"$ref":"#/definitions/d1_params"},"sql":{"$ref":"#/definitions/d1_sql"}},"required":["sql"],"title":"single query"},"d1_params":{"type":"array","items":{"type":"string"},"examples":[["firstParam","secondParam"]]},"d1_sql":{"description":"Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch.","type":"string","examples":["SELECT * FROM myTable WHERE field = ? OR field = ?;"]}}},"name":"Query D1 Database","id":"cloudflare.d1-query-database","example":{"path":{"account_id":"023e105f4ecef8ad9ca31a8372d0c353","database_id":"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"},"body":{"sql":"SELECT * FROM myTable WHERE field = ? OR field = ?;"}},"maxRequests":1,"summary":false}}