Appearance
Schema Advisor
The Schema Advisor is a built-in AI assistant available in every workspace. It helps you understand, design, and improve your database schema through a conversational interface.
What It Does
The Schema Advisor can:
- Explain your schema — describe your tables, columns, types, relationships, and constraints in plain language
- Suggest improvements — recommend normalization, better column types, missing indexes, or naming conventions
- Help with data modeling — advise on how to structure new tables, model relationships (one-to-many, many-to-many), and handle common patterns
- Review constraints — check if your validation rules (required, unique, min/max, regex) are complete and consistent
- Create tables and columns — build out your schema through conversation ("Add an orders table with customer_id, total, and status columns")
- Plan schema changes — help you think through the impact of adding, renaming, or removing columns before you make the change
What It Doesn't Do
The Schema Advisor only reads schema metadata (table names, column definitions, types, constraints). It does not:
- Read, modify, or access your actual row data
- Execute schema changes directly
- Access other workspaces in your organisation
Data operations via MCP
For AI-powered data queries, record creation, and schema modifications, connect your own AI client (Claude Desktop, Cursor, or any MCP-compatible tool) to your workspace via MCP integration. Your data stays in your AI account — SchemaStack just provides the tools.
How to Use
- Open any view in the spreadsheet interface
- Click the robot icon in the toolbar
- A floating chat window appears — ask your question
Example Questions
| Question | What it does |
|---|---|
| "What tables do I have?" | Lists all views with column counts |
| "Describe the orders table" | Shows all columns, types, constraints, and relationships |
| "Should I add an index on customer email?" | Analyzes the column and advises based on your schema |
| "How should I model tags for products?" | Suggests a many-to-many pattern with a junction table |
| "What foreign keys does the orders table have?" | Shows relationship details |
| "Is my schema normalized?" | Reviews your table structure and suggests improvements |
| "Create a tags table with name and slug columns" | Creates the table and columns in your database |
| "Add an email column to the customers table" | Adds the column with appropriate type and constraints |
Privacy
The Schema Advisor sends only schema metadata to the AI service (Anthropic Claude) — table names, column names, types, and constraints. Your actual data rows are never sent. For details on Anthropic's data handling, see Anthropic's privacy policy.
Availability
The Schema Advisor is available on all plans with daily message limits:
| Plan | AI messages/day per member |
|---|---|
| Free | 3 |
| Pro | 20 |
| Enterprise | Unlimited |