How to Use Airtable as a Database: Simple No-Code Guide

To use Airtable as a database, create a base with tables and fields to store your data, then access it via Airtable's API or built-in integrations. You can connect Airtable to apps or websites using API keys and endpoints to read, add, or update records without coding.

Syntax

Airtable uses a REST API to interact with your data. The basic syntax for accessing records is:

• GET https://api.airtable.com/v0/{baseId}/{tableName} - to read records
• POST https://api.airtable.com/v0/{baseId}/{tableName} - to add records
• PATCH https://api.airtable.com/v0/{baseId}/{tableName}/{recordId} - to update records

Each request requires an Authorization header with your API key and uses JSON format for data.

bash

curl -X GET \
  'https://api.airtable.com/v0/app12345/Table%201' \
  -H 'Authorization: Bearer keyYourAPIKey' \
  -H 'Content-Type: application/json'

Example

This example shows how to fetch records from an Airtable base using JavaScript with fetch. It reads data from a table and logs the records.

javascript

const baseId = 'app12345';
const tableName = 'Table 1';
const apiKey = 'keyYourAPIKey';

fetch(`https://api.airtable.com/v0/${baseId}/${encodeURIComponent(tableName)}`, {
  headers: {
    Authorization: `Bearer ${apiKey}`
  }
})
  .then(response => response.json())
  .then(data => {
    data.records.forEach(record => {
      console.log(record.fields);
    });
  })
  .catch(error => console.error('Error:', error));

Output

{ Name: 'John Doe', Email: '[e-mail]' }
{ Name: 'Jane Smith', Email: '[e-mail]' }

Common Pitfalls

Common mistakes when using Airtable as a database include:

• Not URL encoding table names with spaces or special characters.
• Forgetting to include the Authorization header with the API key.
• Exceeding Airtable API rate limits (5 requests per second).
• Confusing field names or using incorrect JSON structure when adding or updating records.

Always check your API key permissions and base ID carefully.

javascript

/* Wrong: Missing Authorization header */
fetch('https://api.airtable.com/v0/app12345/Table%201')
  .then(res => res.json())
  .then(console.log);

/* Right: Include Authorization header */
fetch('https://api.airtable.com/v0/app12345/Table%201', {
  headers: { Authorization: 'Bearer keyYourAPIKey' }
})
  .then(res => res.json())
  .then(console.log);

Quick Reference

Action	HTTP Method	Endpoint Example	Notes
Read records	GET	https://api.airtable.com/v0/{baseId}/{tableName}	Returns list of records
Add record	POST	https://api.airtable.com/v0/{baseId}/{tableName}	Send JSON with fields to add
Update record	PATCH	https://api.airtable.com/v0/{baseId}/{tableName}/{recordId}	Update specific record fields
Delete record	DELETE	https://api.airtable.com/v0/{baseId}/{tableName}/{recordId}	Remove a record

Key Takeaways

Create an Airtable base and tables to organize your data before using the API.

Use the Airtable API with proper Authorization headers to read, add, or update records.

Always URL encode table names and check your API key permissions.

Watch out for API rate limits and correct JSON formatting to avoid errors.

Airtable is a flexible no-code database ideal for simple apps and integrations.