Advanced features let you go beyond field-level search configuration: query tables directly with SQL, diagnose schema and sync issues, and enrich tables with AI-proposed columns. Use these tools once you're comfortable with the core table and field-role workflow.
1. Search Capabilities
Semantic Search
Find content based on meaning and context using natural language queries against fields marked Vectorize.
- Interprets intent, not just exact wording
- Matches across long-form or unstructured content
- Prioritizes conceptual relevance
Filtered Search
Narrow results by exact value using fields marked Filter — status, category, date, or connection — combined with a semantic query.
Use semantic search for discovery and exploration. Use Filter-role fields for precision and scoping.
2. SQL Console
For pro-code access, the SQL Console lets you query MergeBase tables directly with SQL — useful for ad-hoc analysis, joins across tables, or validating data outside of the standard table view. AI-assisted SQL generation can turn a plain-language request into a starting query, which you can then edit and run.
3. Knowledge Report
The Knowledge Report is a diagnostic view over your MergeBase tables — it surfaces schema issues, misconfigured field roles, and sync problems so you can catch data-quality issues before they affect search or workflow results.
4. AI Column (Enrichment)
Beyond manual schema edits, you can add derived columns by describing what you want in plain language. See the Enrichment Tool guide for the full AI Column workflow — proposing a formula, previewing results, and confirming before it's added to the table.
5. Field Configuration at Scale
When you're managing many tables:
- Revisit Configure AI Search after any schema change — new fields default to a role that may not fit your use case
- Keep field-role conventions consistent across tables in the same Collection so search behavior is predictable
- Use the Knowledge Report to spot tables that haven't been reconfigured after a schema change