--- title: Raw D1 Database query --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api/go) [D1](https://developers.cloudflare.com/api/go/resources/d1) [Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database) Copy Markdown Open in **Claude**Open in **ChatGPT**Open in **Cursor** --- **Copy Markdown****View as Markdown** # Raw D1 Database query client.D1.Database.Raw(ctx, databaseID, params) (\*SinglePage\[[DatabaseRawResponse]()], error) POST/accounts/{account\_id}/d1/database/{database\_id}/raw Execute a SQL query against a D1 database and return result rows as arrays rather than objects. This is a performance-optimized version of the /query endpoint. ##### Security
API Token The preferred authorization scheme for interacting with the Cloudflare API. Create a token. **Example:**Authorization: Bearer Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY
API Email + API Key The previous authorization scheme for interacting with the Cloudflare API, used in conjunction with a Global API key. **Example:**X-Auth-Email: user@example.com The previous authorization scheme for interacting with the Cloudflare API. When possible, use API tokens instead of Global API keys. **Example:**X-Auth-Key: 144c9defac04969c7bfad8efaa8ea194
##### Accepted Permissions (at least one required) `D1 Read``D1 Write` ##### ParametersExpand Collapse databaseID string D1 database identifier (UUID). [Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(params)%20default%20%3E%20(param)%20database_id%20%3E%20(schema)>)
params DatabaseRawParams AccountID param.Field\[string] Path param: Account identifier tag. maxLength32 Link to this property Sql param.Field\[string] Body param: Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch. Link to this property Params param.Field\[\[]string]Optional Body param Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(method)%20raw%20%3E%20(params)%200>) ##### ReturnsExpand Collapse
type DatabaseRawResponse struct{…}
Meta DatabaseRawResponseMetaOptional ChangedDB boolOptional Denotes if the database has been altered in some way, like deleting rows. Link to this property Changes float64Optional Rough indication of how many rows were modified by the query, as provided by SQLite’s sqlite3_total_changes(). Link to this property Duration float64Optional The duration of the SQL query execution inside the database. Does not include any network communication. Link to this property LastRowID float64Optional The row ID of the last inserted row in a table with an INTEGER PRIMARY KEY as provided by SQLite. Tables created with WITHOUT ROWID do not populate this. Link to this property RowsRead float64Optional Number of rows read during the SQL query execution, including indices (not all rows are necessarily returned). Link to this property RowsWritten float64Optional Number of rows written during the SQL query execution, including indices. Link to this property ServedByColo stringOptional The three letters airport code of the colo that handled the query. Link to this property ServedByPrimary boolOptional Denotes if the query has been handled by the database primary instance. Link to this property
ServedByRegion DatabaseRawResponseMetaServedByRegionOptional Region location hint of the database instance that handled the query. One of the following: const DatabaseRawResponseMetaServedByRegionWnam DatabaseRawResponseMetaServedByRegion = "WNAM" Link to this property const DatabaseRawResponseMetaServedByRegionEnam DatabaseRawResponseMetaServedByRegion = "ENAM" Link to this property const DatabaseRawResponseMetaServedByRegionWeur DatabaseRawResponseMetaServedByRegion = "WEUR" Link to this property const DatabaseRawResponseMetaServedByRegionEeur DatabaseRawResponseMetaServedByRegion = "EEUR" Link to this property const DatabaseRawResponseMetaServedByRegionApac DatabaseRawResponseMetaServedByRegion = "APAC" Link to this property const DatabaseRawResponseMetaServedByRegionOc DatabaseRawResponseMetaServedByRegion = "OC" Link to this property
Link to this property SizeAfter float64Optional Size of the database after the query committed, in bytes. Link to this property
Timings DatabaseRawResponseMetaTimingsOptional Various durations for the query. SqlDurationMs float64Optional The duration of the SQL query execution inside the database. Does not include any network communication. Link to this property
Link to this property
Link to this property
Results DatabaseRawResponseResultsOptional Columns \[]stringOptional Link to this property
Rows \[]\[]unknownOptional One of the following: unknown Link to this property
Link to this property
Link to this property Success boolOptional Link to this property
[Link to this property](<#(resource)%20d1.database%20%3E%20(model)%20DatabaseRawResponse%20%3E%20(schema)>) ### Raw D1 Database query Go HTTPTypeScriptPythonGoTerraform ``` package main import ( "context" "fmt" "github.com/cloudflare/cloudflare-go" "github.com/cloudflare/cloudflare-go/d1" "github.com/cloudflare/cloudflare-go/option" ) func main() { client := cloudflare.NewClient( option.WithAPIToken("Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY"), ) page, err := client.D1.Database.Raw( context.TODO(), "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", d1.DatabaseRawParams{ AccountID: cloudflare.F("023e105f4ecef8ad9ca31a8372d0c353"), Body: d1.DatabaseRawParamsBodyD1SingleQuery{ Sql: cloudflare.F("SELECT * FROM myTable WHERE field = ? OR field = ?;"), }, }, ) if err != nil { panic(err.Error()) } fmt.Printf("%+v\n", page) } ``` 200 example ``` { "errors": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "messages": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "result": [ { "meta": { "changed_db": true, "changes": 0, "duration": 0, "last_row_id": 0, "rows_read": 0, "rows_written": 0, "served_by_colo": "LHR", "served_by_primary": true, "served_by_region": "EEUR", "size_after": 0, "timings": { "sql_duration_ms": 0 } }, "results": { "columns": [ "string" ], "rows": [ [ 0 ] ] }, "success": true } ], "success": true } ``` ##### Returns Examples 200 example ``` { "errors": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "messages": [ { "code": 1000, "message": "message", "documentation_url": "documentation_url", "source": { "pointer": "pointer" } } ], "result": [ { "meta": { "changed_db": true, "changes": 0, "duration": 0, "last_row_id": 0, "rows_read": 0, "rows_written": 0, "served_by_colo": "LHR", "served_by_primary": true, "served_by_region": "EEUR", "size_after": 0, "timings": { "sql_duration_ms": 0 } }, "results": { "columns": [ "string" ], "rows": [ [ 0 ] ] }, "success": true } ], "success": true } ```