--- title: D1 --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api/go) Copy Markdown Open in **Claude**Open in **ChatGPT**Open in **Cursor** --- **Copy Markdown****View as Markdown** # D1 ##### ModelsExpand Collapse

type D1 struct{…} The details of the D1 database.

CreatedAt TimeOptional Specifies the timestamp the resource was created as an ISO8601 string. formatdate-time Link to this property FileSize float64Optional The D1 database’s size, in bytes. Link to this property

Jurisdiction D1JurisdictionOptional Specify the location to restrict the D1 database to run and store data. If this option is present, the location hint is ignored.

One of the following: const D1JurisdictionEu D1Jurisdiction = "eu" Link to this property const D1JurisdictionFedramp D1Jurisdiction = "fedramp" Link to this property const D1JurisdictionUs D1Jurisdiction = "us" Link to this property

Link to this property Name stringOptional D1 database name. Link to this property DeprecatedNumTables float64Optional The number of tables in the D1 database. This count is no longer accurate and should not be relied upon. Link to this property

ReadReplication D1ReadReplicationOptional Configuration for D1 read replication.

Mode D1ReadReplicationMode The read replication mode for the database. Mode ‘auto’ denotes that D1 creates replicas and automatically places them around the world. Mode ‘disabled’ denotes that no database replicas are used.

One of the following: const D1ReadReplicationModeAuto D1ReadReplicationMode = "auto" Link to this property const D1ReadReplicationModeDisabled D1ReadReplicationMode = "disabled" Link to this property

Link to this property

Link to this property UUID stringOptional D1 database identifier (UUID). Link to this property Version stringOptional Link to this property

[Link to this property](<#(resource)%20d1%20%3E%20(model)%20d1%20%3E%20(schema)>) #### D1Database ##### [List D1 Databases](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/list) client.D1.Database.List(ctx, params) (\*V4PagePaginationArray\[[DatabaseListResponse]()], error) GET/accounts/{account\_id}/d1/database ##### [Get D1 Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/get) client.D1.Database.Get(ctx, databaseID, params) (\*[D1](), error) GET/accounts/{account\_id}/d1/database/{database\_id} ##### [Create D1 Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/create) client.D1.Database.New(ctx, params) (\*[D1](), error) POST/accounts/{account\_id}/d1/database ##### [Update D1 Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/update) client.D1.Database.Update(ctx, databaseID, params) (\*[D1](), error) PUT/accounts/{account\_id}/d1/database/{database\_id} ##### [Update D1 Database partially](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/edit) client.D1.Database.Edit(ctx, databaseID, params) (\*[D1](), error) PATCH/accounts/{account\_id}/d1/database/{database\_id} ##### [Delete D1 Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/delete) client.D1.Database.Delete(ctx, databaseID, body) (\*[DatabaseDeleteResponse](), error) DELETE/accounts/{account\_id}/d1/database/{database\_id} ##### [Query D1 Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/query) client.D1.Database.Query(ctx, databaseID, params) (\*SinglePage\[[QueryResult]()], error) POST/accounts/{account\_id}/d1/database/{database\_id}/query ##### [Raw D1 Database query](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/raw) client.D1.Database.Raw(ctx, databaseID, params) (\*SinglePage\[[DatabaseRawResponse]()], error) POST/accounts/{account\_id}/d1/database/{database\_id}/raw ##### [Export D1 Database as SQL](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/export) client.D1.Database.Export(ctx, databaseID, params) (\*[DatabaseExportResponse](), error) POST/accounts/{account\_id}/d1/database/{database\_id}/export ##### [Import SQL into your D1 Database](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/methods/import) client.D1.Database.Import(ctx, databaseID, params) (\*[DatabaseImportResponse](), error) POST/accounts/{account\_id}/d1/database/{database\_id}/import ##### ModelsExpand Collapse

type QueryResult struct{…}

Meta QueryResultMetaOptional

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 QueryResultMetaServedByRegionOptional Region location hint of the database instance that handled the query.

One of the following: const QueryResultMetaServedByRegionWnam QueryResultMetaServedByRegion = "WNAM" Link to this property const QueryResultMetaServedByRegionEnam QueryResultMetaServedByRegion = "ENAM" Link to this property const QueryResultMetaServedByRegionWeur QueryResultMetaServedByRegion = "WEUR" Link to this property const QueryResultMetaServedByRegionEeur QueryResultMetaServedByRegion = "EEUR" Link to this property const QueryResultMetaServedByRegionApac QueryResultMetaServedByRegion = "APAC" Link to this property const QueryResultMetaServedByRegionOc QueryResultMetaServedByRegion = "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 QueryResultMetaTimingsOptional 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 \[]unknownOptional Link to this property Success boolOptional Link to this property

[Link to this property](<#(resource)%20d1.database%20%3E%20(model)%20query_result%20%3E%20(schema)>) #### D1DatabaseTime Travel ##### [Get D1 database bookmark](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/subresources/time_travel/methods/get_bookmark) client.D1.Database.TimeTravel.GetBookmark(ctx, databaseID, params) (\*[DatabaseTimeTravelGetBookmarkResponse](), error) GET/accounts/{account\_id}/d1/database/{database\_id}/time\_travel/bookmark ##### [Restore D1 Database to a bookmark or point in time](https://developers.cloudflare.com/api/go/resources/d1/subresources/database/subresources/time_travel/methods/restore) client.D1.Database.TimeTravel.Restore(ctx, databaseID, params) (\*[DatabaseTimeTravelRestoreResponse](), error) POST/accounts/{account\_id}/d1/database/{database\_id}/time\_travel/restore