SchemaSmith Documentation

Ask Forge Capabilities

47 tools across 4 trust tiers — from read-only analysis to external tool execution.

Ask Forge Capabilities

Ask Forge provides 47 tools that turn any AI assistant into a schema management expert.

Trust Tiers

Ask Forge organizes its 47 tools into four tiers. Access is governed by 3 trust levels — Observer, Assistant, and Operator — each granting progressively more powerful capabilities. Trust levels are configured per-session and can be restricted by administrators. See Trust Levels for full details.

Tier 1 ReadOnly

Read-only exploration and analysis. No changes to schema files.

28 tools

View Tier 1
Tier 2 Generate

AI-powered generation. Creates scripts and plans for your review.

3 tools

View Tier 2
Tier 3 Modify

Modifies schema JSON files. Requires confirmation before each change.

13 tools

View Tier 3
Tier 4 External

Executes external SchemaSmith tools against live databases.

3 tools

View Tier 4

Tool Inventory

All 47 Ask Forge tools organized by trust tier. Select a tier to view its tools.

Tool Category Description
show-context Context & Navigation Show the currently active product, template, and table selection
navigate-context Context & Navigation Set the active product, template, or table (or clear the context)
list-templates Context & Navigation List all templates in the current product
list-tables Context & Navigation List all table names in the current template
show-table Context & Navigation Show full table definition including columns, indexes, and foreign keys
list-folders Context & Navigation List all script folders with summary info
list-scripts Context & Navigation List scripts in a specified folder
list-connections Configuration List configured database connections
show-config Configuration Show current configuration and database connections
show-platform-capabilities Configuration Show platform capabilities, naming rules, and feature support
diff-tables Schema Analysis Compare two table definitions and show differences
review-schema Schema Analysis Analyze schema for naming, indexing, type, relationship, and nullability issues
dependencies Schema Analysis Analyze the FK dependency graph: list, circular, topological, or cascade impact
plan-migration Schema Analysis Generate a migration plan comparing two git refs
show-conventions Schema Analysis Detect naming conventions from the current template
check-data Data Validation Generate SQL to check data quality: nulls, orphans, or duplicates
validate-json Data Validation Validate table JSON against platform schema rules
search-schemas Search Search columns across all tables by name, type, or properties
search-knowledge Search Search the knowledge base for articles and best practices
view-log Diagnostics View or open external tool log files
discover-tools Discovery Find tools by describing what you want to do
execute-tool Discovery Run any tool by name with arguments (pairs with discover-tools)
list-materialized-views Platform Views — PostgreSQL List materialized views in the current template
show-materialized-view Platform Views — PostgreSQL Show a materialized view's full definition
diff-materialized-views Platform Views — PostgreSQL Compare two materialized view definitions
list-indexed-views Platform Views — SQL Server List indexed views in the current template
show-indexed-view Platform Views — SQL Server Show an indexed view's full definition
diff-indexed-views Platform Views — SQL Server Compare two indexed view definitions
Tool Category Description
generate-schema Schema Generation Generate platform-specific table JSON from a blueprint spec
suggest-changes Migration & Planning Analyze a proposed change and get risk assessment and recommendations
manage-connection Configuration Set or clear the database connection for a platform (actions: set, clear)
Tool Category Description
apply-change Schema Modification Modify schema JSON files to apply changes
create-table Schema Modification Create a new table with platform-correct conventions
rename-table Schema Modification Rename a table with cascade through FK references
rename-column Schema Modification Rename a column with full cascade through indexes and FKs
apply-generated-schema Schema Modification Write generated schema tables to the template directory as JSON
save-script File Output Save a SQL script to a script folder in the current product
save-migration File Output Save a migration plan to disk as markdown and SQL files
create-package Deployment & Packaging Create a deployment package (zip) of schema files and scripts
add-folder Deployment & Packaging Create a new script folder with QuenchSlot inference
manage-tokens Advanced Management List, add, update, remove, scan, or suggest script tokens
configure-data-delivery Data Delivery Configure data delivery (MergeType, match columns, filters) on a table
create-materialized-view Platform Objects — PostgreSQL Create a materialized view
create-indexed-view Platform Objects — SQL Server Create an indexed view
Tool Category Description
run-schema-tongs Schema Extraction Extract schema from a database to JSON files
run-schema-quench Schema Deployment Apply schema JSON to a database (defaults to dry-run)
run-data-tongs Data Extraction Extract table data to JSON content files and MERGE scripts

Explore by Tier