What Are Core Tables?

Core tables are the most important tables in your database that you'll interact with frequently. They're automatically identified by our AI when you connect your database, and they serve as the foundation for creating data management interfaces.

Understanding Core Tables

What Makes a Table "Core"?

Core tables are typically:

• Primary data entities - Main business objects (users, products, orders, etc.)
• Frequently accessed - Tables you query and update regularly
• Well-structured - Tables with clear relationships and meaningful data
• Business-critical - Tables central to your application's functionality

How Core Tables Are Identified

When you connect your database, our AI analyzes your schema to identify core tables by looking at:

1. Table relationships - Tables with foreign key relationships
2. Table structure - Well-defined schemas with proper columns
3. Naming patterns - Tables with clear, descriptive names
4. Data patterns - Tables that appear central to your data model

Each core table includes:

• Display Name - A user-friendly name for the table
• Table Name - The actual database table name
• Icon - An icon representing the table type
• Description - A description of what the table is used for

Viewing Core Tables

Core Tables Page

Navigate to your workspace and click on "Core Tables" in the sidebar. You'll see:

• All identified core tables in a grid layout
• Each table card showing:
  • Display name and icon
  • Description/prompt
  • Whether a data interface has been created
  • Last update date
  • Table name

Table Status Indicators

Core tables show different statuses:

• Not Created Yet - Table is identified but no data interface exists
• Data Interface - A data interface has been generated for this table
• Generating... - A data interface is currently being created

Managing Core Tables

Adding Tables to Core Tables

You can manually add tables to your core tables:

1. Go to the Core Tables page
2. Click "Add Core Table" button
3. Select a table from the dropdown (shows tables not already in core)
4. The system will:
   • Add the table to core tables
   • Automatically generate a data interface
   • Create a view for managing that table's data

Note: Adding a table to core tables uses your credit limit, as it generates a new data interface.

Removing Tables from Core Tables

To remove a table from core tables:

1. Hover over a core table card
2. Click the ellipsis menu (three dots)
3. Select "Remove from core tables"
4. Confirm the removal

Important: Removing a table from core tables does NOT:

• Delete the table from your database
• Delete any existing data interfaces/views
• Remove any data from the table

It only removes the table from the core tables list, so it won't appear in the core tables view anymore.

Automatic View Generation

What Happens When You Add a Core Table?

When you add a table to core tables, our AI automatically creates a complete data interface for you:

1. Analyzes your table - Understands what columns you have and how they're related
2. Creates smart filters - Adds filters that make sense for your data (date ranges, dropdowns, search)
3. Sets up pagination - Handles large amounts of data smoothly
4. Creates the interface - Builds a complete interface for viewing, searching, and editing your data

Generated View Components

Each generated view includes:

• Data Table - A table interface for viewing and managing your data
• Filters - Smart filters based on column types (date ranges, dropdowns, search)
• Pagination - Server-side pagination for handling large datasets
• Inline Editing - Click rows to edit them directly
• Form Generation - Forms for creating and updating records

Core Tables vs Data Interfaces

Core Tables

Core tables are the list of important tables in your database. They help you organize which tables you want to work with most often.

Data Interfaces

When you add a table to core tables, a data interface is automatically created. This is what you actually use to view, search, filter, and edit your data.

In simple terms: Core tables are your "favorites" list, and data interfaces are the actual tools you use to work with those tables.

Best Practices

Choosing Core Tables

• Start with essentials - Focus on your most important tables first
• Consider usage - Add tables you'll query frequently
• Think about workflows - Include tables that are part of your main workflows
• Don't overdo it - Too many core tables can clutter your interface

Managing Core Tables

• Review regularly - Periodically review which tables are truly "core"
• Remove unused - Remove tables you no longer need quick access to
• Use search - The search feature helps find tables quickly
• Organize by workflow - Group related tables together mentally

Data Interface Generation

• Let AI do the work - The automatic generation handles most cases well
• Customize after - You can always modify data interfaces after they're created
• Test with your data - Make sure everything works as expected
• Iterate - You can regenerate or modify interfaces anytime

Troubleshooting

Table Not Appearing in Core Tables

• Check if the table exists in your database
• Verify the table has been discovered in schema analysis
• Try refreshing your workspace

Data Interface Generation Failed

• Check your account credits
• Make sure the table has data in it
• Try adding the table again
• Contact support if the problem persists

Data Interface Not Working Correctly

• Try refreshing the page
• Check if the table still exists in your database
• Remove and re-add the table to core tables
• Contact support for help

Related Documentation

• Connect Your First Database - Setting up your database connection
• Get Started - Overview of features
• Natural Language Queries - Querying your data