Cloudflare D1

Query and manage Cloudflare D1 serverless SQL databases

Actions5

Database Actions
Query Actions
- Execute
- Execute Raw

Overview

This node interacts with Cloudflare D1, a serverless SQL database service. Specifically, the Database - List operation retrieves a list of all D1 databases associated with the user's Cloudflare account.

Common scenarios where this node is useful include:

Fetching available databases to display or use in subsequent workflow steps.
Auditing or monitoring existing databases programmatically.
Automating workflows that depend on dynamically retrieving database information.

For example, you might use this node to get a list of databases and then loop over them to perform queries or maintenance tasks.

Properties

Name	Meaning
Options	Collection of optional parameters:
Limit	Maximum number of database results to return (minimum 1, default 50)

Output

The output is an array of JSON objects representing the databases retrieved from Cloudflare D1.

The json field contains the list of databases under the root object.
Each item corresponds to one database entry as returned by the Cloudflare API.
If the request is successful, the output includes the database details such as their IDs, names, and other metadata.
In case of failure, error information is included if "Continue On Fail" is enabled.

No binary data is produced by this operation.

Dependencies

Requires a valid Cloudflare API key credential with permissions to access D1 databases.
Needs the Cloudflare account ID and API token configured in the node credentials.
The node makes HTTP requests to the Cloudflare API endpoint: https://api.cloudflare.com/client/v4/accounts/{accountId}/d1/database.

Troubleshooting

Common issues:
- Invalid or missing API credentials will cause authentication failures.
- Exceeding API rate limits may result in errors.
- Specifying a limit less than 1 will be rejected by the node's input validation.
Error messages:
- "Request failed": Generic failure from the Cloudflare API; check network connectivity and API status.
- "Database \"<name>\" not found": Not applicable for the List operation but relevant for delete operations.
- Errors related to authorization typically indicate invalid or insufficient API tokens.
Resolution tips:
- Verify that the API token has the necessary scopes for D1 database management.
- Ensure the account ID matches the Cloudflare account owning the databases.
- Use the "Continue On Fail" option to handle errors gracefully within workflows.