Managing Tables

Tables are where your data lives. In DYPAI, managing tables is as simple as editing a document.

The Visual Editor

You can find the Visual Editor in the Database section of your project dashboard. It allows you to perform all essential operations without writing a single line of SQL.

Creating a Table

1. Click on New Table.
2. Give your table a name (e.g., products).
3. Add the columns you need.
4. Click Save.

Column Types

DYPAI supports the full power of PostgreSQL. While you can use any standard Postgres type, here are the most commonly used ones in the Visual Editor:

• Text: For names, emails, or long descriptions (text, varchar).
• Numbers: For prices, quantities, or IDs (int8, numeric, float).
• Boolean: For "yes/no" flags (bool).
• Date/Time: For timestamps and scheduling (timestamptz, date).
• JSONB: For flexible, nested data or dynamic metadata.
• UUID: For globally unique identifiers (recommended for primary keys).
• Arrays: Store lists of values in a single column (e.g., text[]).

Connecting to APIs

After creating a table, you'll want to interact with it. You can create custom endpoints in the API Builder section to handle:

• Listing and searching records.
• Creating and updating data.
• Executing custom business logic.

The fastest way to set these up is by asking the AI via MCP: "Create a CRUD API for my products table."

Relationships

You can connect tables to each other (e.g., connecting an order to a user). The Visual Editor makes it easy to define these links so your data stays organized and consistent.