---
title: Best practices
description: Recommended patterns and techniques for building with D1 databases.
image: https://developers.cloudflare.com/dev-products-preview.png
---

> Documentation Index  
> Fetch the complete documentation index at: https://developers.cloudflare.com/d1/llms.txt  
> Use this file to discover all available pages before exploring further.

[Skip to content](#%5Ftop) 

# Best practices

* [ Import and export data ](https://developers.cloudflare.com/d1/best-practices/import-export-data/)
* [ Query a database ](https://developers.cloudflare.com/d1/best-practices/query-d1/)
* [ Retry queries ](https://developers.cloudflare.com/d1/best-practices/retry-queries/)
* [ Use indexes ](https://developers.cloudflare.com/d1/best-practices/use-indexes/)
* [ Local development ](https://developers.cloudflare.com/d1/best-practices/local-development/)
* [ Remote development ](https://developers.cloudflare.com/d1/best-practices/remote-development/)
* [ Use D1 from Pages ](https://developers.cloudflare.com/pages/functions/bindings/#d1-databases)
* [ Global read replication ](https://developers.cloudflare.com/d1/best-practices/read-replication/)

```json
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"item":{"@id":"/directory/","name":"Directory"}},{"@type":"ListItem","position":2,"item":{"@id":"/d1/","name":"D1"}},{"@type":"ListItem","position":3,"item":{"@id":"/d1/best-practices/","name":"Best practices"}}]}
```