Native Database Integrations

Connect to databases using the new Database Integrations (beta) experience. Enable native Database Integrations in the Cloudflare dashboard Open external link . With native Database Integrations, Cloudflare automatically handles the process of creating a connection string and adding it as secrets to your Worker.

​​ Database credentials

If you rotate or delete database credentials, you must delete the integration and go through the setup flow again.

​​ Database limits

At this time, Database Integrations only support access to one database per provider. To add multiple, you must manually configure secrets.

​​ Supported platforms

​​ PlanetScale

PlanetScale Open external link is a MySQL-compatible platform that makes databases infinitely scalable, easier and safer to manage.

1. To set up an integration with PlanetScale, you need to have an existing PlanetScale database to connect to. Create a PlanetScale database Open external link or import an existing database to PlanetScale Open external link .

2. From the PlanetScale web console Open external link , create a products table with the following query:

   CREATE TABLE products (
     id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
     name varchar(255) NOT NULL,
     image_url varchar(255),
     category_id INT,
     KEY category_id_idx (category_id)
   );
   

3. Insert some data in your newly created table. Run the following command to add a product and category to your table:

   INSERT INTO products (name, image_url, category_id)
   VALUES  ('Ballpoint pen', 'https://example.com/500x500', '1');
   

4. Add the PlanetScale integration to your Worker:

   1. Log in to the Cloudflare dashboard Open external link and select your account.
   2. In Account Home, select Workers & Pages.
   3. In Overview, select your Worker.
   4. Select Settings > Integrations > PlanetScale.
   5. Follow the setup flow, selecting the database created in step 1.

5. In your Worker, install the @planetscale/database driver to connect to your PlanetScale database and start manipulating data:

   npm install @planetscale/database

6. The following example shows how to make a query to your PlanetScale database in a Worker. The credentials needed to connect to PlanetScale have been automatically added as secrets to your Worker through the integration.

   import { connect } from '@planetscale/database';
   
   export default {
     async fetch(request, env) {
       const config = {
         host: env.DATABASE_HOST,
         username: env.DATABASE_USERNAME,
         password: env.DATABASE_PASSWORD,
   		      fetch: (url, init) => {
   			    delete (init)["cache"];
   			    return fetch(url, init);
         }
       }
   
       const conn = connect(config)
       const data = await conn.execute('SELECT * FROM products;')
       return new Response(JSON.stringify(data.rows), {
         status: 200,
         headers: {
           'Content-Type': 'application/json'
         }
       });
     },
   };
   

To learn more about PlanetScale, refer to Planetscale’s official documentation Open external link .

​​ Supabase

Supabase Open external link is an open source Firebase alternative and a PostgreSQL database service that offers real-time functionality, database backups, and extensions. With Supabase, developers can quickly set up a PostgreSQL database and build applications.

1. To set up an integration with Supabase, you need to have an existing Supabase database to connect to. Create a Supabase database Open external link or have an existing database to connect to Supabase and load data from Open external link .

2. Create a countries table with the following query. You can create a table in your Supabase dashboard in two ways:

   • Use the table editor, which allows you to set up Postgres similar to a spreadsheet.
   • Alternatively, use the SQL editor Open external link :

   CREATE TABLE countries (
   id SERIAL PRIMARY KEY,
   name VARCHAR(255) NOT NULL
   );
   

3. Insert some data in your newly created table. Run the following commands to add countries to your table:

   INSERT INTO countries (name) VALUES ('United States');
   INSERT INTO countries (name) VALUES ('Canada');
   INSERT INTO countries (name) VALUES ('The Netherlands');
   

4. Add the Supabase database integration to your Worker:

   1. Log in to the Cloudflare dashboard Open external link and select your account.
   2. In Account Home, select Workers & Pages.
   3. In Overview, select your Worker.
   4. Select Settings > Integrations > Supabase.
   5. Follow the setup flow, selecting the database created in step 1.

5. In your Worker, install the @supabase/supabase-js driver to connect to your database and start manipulating data:

   npm install @supabase/supabase-js

6. The following example shows how to make a query to your Supabase database in a Worker. The credentials needed to connect to Supabase have been automatically added as secrets to your Worker through the integration.

   import { createClient } from '@supabase/supabase-js';
   
   export default {
     async fetch(request, env) {
       const supabase = createClient(env.SUPABASE_URL, env.SUPABASE_KEY);
       const { data, error } = await supabase.from("countries").select('*');
       if (error) throw error;
       return new Response(JSON.stringify(data), {
         headers: {
           "Content-Type": "application/json",
         },
       });
     },
   };
   

To learn more about Supabase, refer to Supabase’s official documentation Open external link .

​​ Neon

Neon Open external link is a fully managed serverless PostgreSQL. It separates storage and compute to offer modern developer features, such as serverless, branching, and bottomless storage.

1. To set up an integration with Neon, you need to have an existing Neon database to connect to. Create a Neon database Open external link or load data from an existing database to Neon Open external link .

2. Create an elements table using the Neon SQL editor. The SQL Editor allows you to query your databases directly from the Neon Console.

   CREATE TABLE elements (
     id INTEGER NOT NULL,
     elementName TEXT NOT NULL,
     atomicNumber INTEGER NOT NULL,
     symbol TEXT NOT NULL
   );
   

3. Insert some data into your newly created table.

   INSERT INTO elements (id, elementName, atomicNumber, symbol)
   VALUES
     (1, 'Hydrogen', 1, 'H'),
     (2, 'Helium', 2, 'He'),
     (3, 'Lithium', 3, 'Li'),
     (4, 'Beryllium', 4, 'Be'),
     (5, 'Boron', 5, 'B'),
     (6, 'Carbon', 6, 'C'),
     (7, 'Nitrogen', 7, 'N'),
     (8, 'Oxygen', 8, 'O'),
     (9, 'Fluorine', 9, 'F'),
     (10, 'Neon', 10, 'Ne');
   

4. Add the Neon database integration to your Worker:

   1. Log in to the Cloudflare dashboard Open external link and select your account.
   2. In Account Home, select Workers & Pages.
   3. In Overview, select your Worker.
   4. Select Settings > Integrations > Neon.
   5. Follow the setup flow, selecting the database created in step 1.

5. In your Worker, install the @neondatabase/serverless driver to connect to your database and start manipulating data:

   npm install @neondatabase/serverless

6. The following example shows how to make a query to your Neon database in a Worker. The credentials needed to connect to Neon have been automatically added as secrets to your Worker through the integration.

   import { Client } from '@neondatabase/serverless';
   
   export default {
     async fetch(request, env, ctx) {
       const client = new Client(env.DATABASE_URL);
       await client.connect();
       const { rows } = await client.query('SELECT * FROM elements');
       ctx.waitUntil(client.end());  // this doesn’t hold up the response
   
       return new Response(JSON.stringify(rows));
     }
   }

To learn more about Neon, refer to Neon’s official documentation Open external link .