Creating Database Tables

Tables define how your data is organized. Each table stores a specific type of information.

Who can do this: Owners, Admins, and Editors can create and edit database tables. See Roles and Permissions for details.

Creating Tables via Chat

Describe what data you need to store:

“Create a table for contact form submissions with name, email, message, and submission date”

“Set up a products table with name, description, price, and image URL”

“I need a table for blog posts with title, content, author, and published date”

Sticklight creates the appropriate table structure with proper field types.

Common Table Patterns

Contact submissions:

• name (text)
• email (text)
• message (text)
• created_at (timestamp)

Blog posts:

• title (text)
• content (text)
• author (text)
• published_at (timestamp)
• is_published (boolean)

Products:

• name (text)
• description (text)
• price (number)
• image_url (text)
• in_stock (boolean)

Team members:

• name (text)
• role (text)
• bio (text)
• photo_url (text)
• order (number)

Field Types

Sticklight uses appropriate types based on your description:

• Text – Names, descriptions, content
• Number – Prices, quantities, order
• Boolean – True/false flags (published, active, featured)
• Timestamp – Dates and times
• UUID – Unique identifiers

Modifying Tables

Add or change fields as needed:

“Add a phone number field to the contacts table”

“Add a featured flag to the blog posts table”

“Remove the middle name field from the team table”

Viewing Table Structure

See your table schema in the Data panel:

1. Click Dashboard in the top navigation bar
2. Select the Data tab
3. Hover over Data to see your available tables
4. Click a table name to view its contents

The Data tab is available after enabling Cloud Backend.

Data View Layout

Once you select a table, you will see:

• Table name displayed at the top
• Search bar to find specific records
• New item button to add records
• Table menu (three dots) for additional options
• Data grid showing your records in rows and columns
• Pagination at the bottom for navigating large datasets

Viewing Data

Browse records:
Scroll through your data or use pagination for large tables.

Search:
Find specific records by searching text fields.

Sort:
Click column headers to sort ascending or descending.

Table Menu Options

Click the three-dot menu in the top right of the data view to access:

• Export data – Download your table as a file for backups, analysis, or sharing
• Schema – View your table structure including column names, data types, and constraints
• Delete table – Permanently remove the table and all its data

Only Owners and Admins can delete tables.

To add, edit, or delete individual records, see Data Management.