Schema Builder

Define any data model, visually

Create custom entity types with a drag-and-drop field builder. Model products, leads, articles, competitors — anything. 18 field types, 4 view types, and dynamic columns that adapt to your schema.

app.wiserows.com/schema-builder
Schema Builder showing entity type cards with field counts, icons, and color-coded categories

18 field types

From simple text to AI-generated fields, every data type you need is built in.

Text & Rich Text
Plain text, long text, and rich text with formatting
Numbers & Dates
Number, date, datetime with validation rules
Select & Multi-select
Single or multi-select with custom options
Files & Images
File uploads and image fields with preview
Reference & Relation
Foreign key references and many-to-many relations
JSON & Formula
Raw JSON storage and computed formula fields
AI Generated
Fields that auto-populate using AI with prompt templates
URL, Email & Boolean
Validated URLs, emails, and toggle fields

4 ways to see your data

Switch between views instantly. Each entity type can have a different default view.

Table View

Dynamic TanStack Table with sortable columns, filters, global search, column visibility, row selection, and pagination. Columns auto-generated from your schema.

Learn more

Kanban View

Drag-and-drop kanban board grouped by any select field. Move entities between stages visually.

Learn more

Gallery View

Card grid view with image previews. Configure which fields appear on cards for a visual overview.

Learn more

Calendar View

Calendar layout driven by any date field. View and manage entities on a timeline.

Learn more

Dynamic table columns

Table columns are generated automatically from your entity schema. Toggle which fields appear in the table, rearrange column order, and get the right filter for every field type.

  • Columns auto-generated from entity type fields
  • Global search across all visible columns
  • Column-specific filters (text search, date range, select dropdown)
  • Row selection with shift-click for bulk actions
  • Sortable columns with multi-sort support
  • Column visibility toggle and reordering
app.wiserows.com/data/products
Data table view with inline editing, filtering, sorting, and column statistics

Schema as structured data

Every entity type you build is stored as structured schema data. This powers dynamic columns, form generation, validation, AI prompts, and integration field mapping — all from a single source of truth.

  • Schema drives table columns, form fields, and API shape
  • Field validation rules enforced automatically
  • AI prompt templates reference schema fields
  • Integration field mapping reads from schema
Entity Type Schema
{
'name': 'Blog Post',
'slug': 'blog-post',
'icon': 'newspaper',
'fields': [
{
'name': 'Title',
'type': 'text',
'required': true,
'showInTable': true
},
{
'name': 'Body',
'type': 'richText',
'required': true,
'showInTable': false
},
{
'name': 'Status',
'type': 'select',
'config': {...} (1 item)
},
{
'name': 'Featured Image',
'type': 'image',
'required': false
},
{
'name': 'SEO Description',
'type': 'aiGenerated',
'config': {...} (1 item)
}
],
'defaultView': 'table',
'contentGeneration': {
'enabled': true,
'batchSize': 20
}
}

Organized in your sidebar

Entity types appear in your sidebar, organized into sections you define: Data, Content, Marketing, or custom categories. Each with its own icon and color.

  • Entity types become navigation items automatically
  • Organize into custom sidebar sections
  • Choose from 30+ Lucide icons per entity type
  • Color-coded section dots for quick scanning
  • Per-entity-type permission overrides
app.wiserows.com/overview
WISEROWS app showing sidebar navigation with entity types, sections, and icons

AI schema suggestion

Import a CSV or paste sample data and let AI suggest the optimal schema. Field types, validation rules, and display settings — all inferred automatically.

  • Import CSV and auto-detect field types
  • AI suggests field names and validation rules
  • Review and customize before creating
  • Bulk import data after schema creation
Schema Suggestion
AI detected 5 fields from your CSV
name
text98%
price
number95%
category
select92%
image_url
image88%
description
richText85%

Data quality tools

Built-in tools to keep your data clean. Column statistics, completeness checks, and health indicators help you spot issues before they become problems.

  • Column statistics (fill rate, unique values, distribution)
  • Completeness scoring per entity
  • Data health indicators on the table view
  • Missing field detection and alerts
Data Quality Overview
Title100%
Description87%
SEO Meta62%
Featured Image45%
Category93%

Bulk operations

Select rows, then update, delete, or enrich in bulk. Background jobs handle the heavy lifting while you keep working.

  • Multi-select with shift-click
  • Bulk update any field across selected entities
  • Bulk delete with confirmation
  • Bulk AI enrichment with background jobs
  • Progress tracking for long-running operations
Bulk Operations
23 selected
Update
Delete
Enrich
Export

Saved views & filters

Create named filter presets for common queries. Share views with your team so everyone sees the data they need.

  • Named filter presets
  • Save column visibility and sort order
  • Shareable view links
  • Quick-switch between saved views
Saved Views
All Products
No filters
1,240 rows
Needs Description
description is empty
89 rows
Published This Week
status = published, date >= 7d
12 rows
High Priority SEO
seo_score < 60, traffic > 100
34 rows
How it feels

Changes appear instantly. Drag a field in the schema builder and watch the table update in real time. No deploy step, no page refresh, no waiting. Your schema is live the moment you save it — and your team sees the change on their screen within milliseconds.

Frequently asked questions

Your data is incomplete. Fix it.

Define your schema. Import your data. Let AI enrich every record. See quality scores improve in real time. Free to start, no credit card.

Command Palette

Search for a command to run...