> For the complete documentation index, see [llms.txt](https://bluebase.gitbook.io/core/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://bluebase.gitbook.io/core/tutorial/1.-create-a-backend-api/create-a-new-plugin.md).

# 2.1 Create Backend API

Before we start creating our app, we first need to create an API connected to a database. For this purpose, we will use a free tool called [Supabase](https://supabase.io).

### Step 1: Sign up

Go to [supabase.com](https://supabase.com) and Sign up to create a new account.

![](/files/x4Qihta6uCukHIV5tSlX)

### **Step 2: Create a New Project**

Next, we need to create a new project. Click the "New Project" button once you login into the Supabase app, and follow the wizard to create your API project.

![2a. Click "New Project"](/files/9IKazHjwCLkaeOngfd99) ![2b. Enter Organization Name](/files/9zwgrx8R4DleofEBVKNb) ![2c. Enter project details](/files/LzUq9abTOLdGcBRaF2AS) ![2d. Project dashboard](/files/dQKINVUPClV8Qdohxykl)

### **3. Create Database Table**

Now we need to create our database table to store our to-do tasks.

Start by clicking the Table Editor button on the left sidebar menu. Once you're on this page, press the "Create a new table" button.

![Press the "Create a new table" button](/files/A0rXAXPcJtvrwJ1vZ884)

When the form opens, add the following columns to match the screenshot below:

1. id (uuid)
2. title (varchar)
3. description (text)
4. completed (bool)
5. created\_at (timestamptz)

Make sure "Enable Row Level Security" is <mark style="color:red;">**NOT**</mark> checked.

![Add table columns](/files/dQBVqaMmW06C21iX2f4j)

### **4. Build GraphQL Schema**

Since we are going to be building our app on top of [GraphQL](https://graphql.org/) query language, we need to tell Supabase to build its schema.

On the left sidebar menu click the "SQL Editor" button. Once on this screen, press the "+ New Query" button.&#x20;

![](/files/ABPA3YDkvBZeKVvEIdUq)

Now enter the following code snippet in the editor and press "RUN"

```sql
-- Rebuild the GraphQL Schema Cache
select graphql.rebuild_schema();
```

![](/files/HNWwLJpH4KBdqvLCfgpL)

### 5. API Details

Go to `Settings => API` page. Here you can find the API URL and Key as shown in the screenshot below.

![](/files/peApLMPoWUaYlC41ECPJ)

That's all. We're done with creating our API for the project. All we need to do is consume it now.