Skip to main content
When you add a datasource, Mora syncs a catalog — a structured snapshot of every schema, table, and column in your database. The catalog powers several features:
  • SQL autocomplete — table and column names are suggested as you type in the editor.
  • AI schema search — the AI assistant can search the catalog to find the right tables for your question, even when you don’t know the exact names.
  • AI-generated descriptions — Mora can use AI to generate plain-language descriptions of your tables and columns, making the catalog even more useful for search.

​
How sync works

Catalog sync runs automatically when a datasource is created and can be triggered manually from the datasource detail page. The sync:
  1. Connects to your database using the datasource credentials.
  2. Reads the information schema to discover all schemas, tables, and columns.
  3. Stores the result in Mora so it’s available instantly for autocomplete and AI.
Syncing does not read or copy your actual data — only metadata (names, types, descriptions).

​
AI-powered descriptions

Mora can generate descriptions for your tables and columns using AI. These descriptions are indexed for semantic search, so the AI assistant can find relevant tables even when your question doesn’t match exact column names. For example, if your table is called trx but you ask the AI about “transactions,” the description helps bridge that gap.

​
Browsing the catalog

The catalog is visible in the dataset editor’s left panel. Expand a schema to see its tables, and expand a table to see its columns with types.