Skip to main content
Closot
LoginTry for free

Create a Database

Image

Time to build a database and explore its core capabilities — properties, views, filters, and sorts — hands-on.

Create a New Database​

  1. Open a new page and type /list on any existing page
  2. The first column holds your page names; every additional column is a property
  3. To change a property type, click the property name → Edit property → Change type

Image

Create a Database with Closot AI​

Closot AI can scaffold a database for you based on a plain-language description.

From a Page​

  1. Create a new page and select ••• → List, or use /database
  2. Click Build with AI in the menu
  3. Describe what you need (e.g., "a customer feedback tracker with priority levels, status, and assignee")
  4. Review the preview and adjust anything you'd like to change
  5. Click Continue, then choose a visualization format and click Done

From Home​

  1. Switch to Build mode in the Closot AI widget on your Home screen
  2. Describe the database you want to create
  3. Review and refine the preview
  4. Click Continue, choose a visualization, then click Done
warning

AI-generated databases can't edit existing databases and can't create pages, automations, forms, charts, or templates inside the database at creation time. The resulting database is placed as a new page in your workspace — you can move it wherever you like afterward.

Create a Database from a Template​

  1. Create a new page and select Database under "Get started with"
  2. Browse Suggested templates or explore more from the full list
  3. Pick a template and click Get started

Add Data to Your Database​

Here's a practical example using a task database:

  1. Click New page to add a task row
  2. Add a priority property:
    • Click Add property, give it a name, and select a property type
    • Click the property name → Edit property → add options (e.g., P1, P2, P3)
  3. Add a due date property:
    • Click + to add a property, name it "Due date," and select the Date type
    • A date picker will appear whenever you edit that field

Open a Row as a Page​

Every row in a database is also a full page with its own content area.

  1. Hover over a cell in the Name column and click Open
  2. Add or edit properties from the page view
  3. Write content, add blocks, embed files — just like any other Closot page

Create New Database Views​

  1. Click the + button next to the current view name at the top of your database
  2. Select a view type — for example, Board
  3. Your rows now display as cards grouped by a property like Status

Image

tip

Other useful view types: Gallery for image-heavy databases, List for minimal documentation, Calendar for date-based content, and Timeline for visualizing project durations.

Filter and Sort Your Data​

  1. Open the settings menu at the top right of your database
  2. Select Filter or Sort
  3. Choose the property to filter or sort by (e.g., filter for P1 tasks only, or sort by due date ascending)
  4. The database updates instantly — you can stack multiple filters and sorts at the same time Image

Up next: Start with a template — Skip the blank page and hit the ground running with a ready-made structure.