SchemaSmith Documentation
Ask Forge Capabilities
46 tools across 4 trust tiers — from read-only analysis to external tool execution.
46 tools across 4 trust tiers — from read-only analysis to external tool execution.
Ask Forge organizes its 46 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.
All 46 Ask Forge tools organized by trust tier. Select a tier to view its tools.
| Tool | Category | Description |
|---|---|---|
show-context |
Context & Navigation | Show current product, template, and table selection |
show-table |
Context & Navigation | Show table structure including columns, keys, and indexes |
list-tables |
Context & Navigation | List all tables in the current template |
list-templates |
Context & Navigation | List all templates in the current product |
list-folders |
Context & Navigation | List all script folders with summary info |
list-scripts |
Context & Navigation | List scripts in a specified folder |
show-config |
Configuration | Show current configuration including connections and tool paths |
list-connections |
Configuration | List configured database connections with server and user info |
show-platform-capabilities |
Configuration | Show platform feature support, naming rules, and capabilities |
check-nulls |
Data Validation | Generate a query to check for NULL values in a column |
check-orphans |
Data Validation | Generate a query to check for orphaned foreign key references |
check-duplicates |
Data Validation | Generate a query to check for duplicate values in columns |
check-naming |
Data Validation | Check naming conventions against platform rules |
show-dependencies |
Schema Analysis | Show foreign key dependency graph for a table |
show-all-dependencies |
Schema Analysis | Show all foreign key relationships across the entire template |
analyze-dependency-graph |
Schema Analysis | Detect circular dependencies, topological ordering, and cascade impact |
show-conventions |
Schema Analysis | Detect and display naming conventions from the current template |
diff-tables |
Schema Analysis | Compare two table definitions and show differences |
review-schema |
Schema Analysis | Run a comprehensive schema review with severity and recommendations |
analyze-indexes |
Schema Analysis | Analyze index coverage, missing FK indexes, and redundancy |
plan-migration |
Schema Analysis | Compare schema between git refs and produce a migration plan |
search-knowledge |
Search | Search the knowledge base for articles and best practices |
search-schemas |
Search | Search columns across all tables by name, type, or table |
validate-json |
Utilities | Validate table or template JSON structure for issues |
| Tool | Category | Description |
|---|---|---|
generate-migration |
Migration & Planning | Generate a SQL migration script for a schema change |
suggest-changes |
Migration & Planning | Analyze a proposed change and get risk assessment and recommendations |
generate-schema |
Schema Generation | Generate platform-specific table JSON from a blueprint spec |
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 |
set-connection |
Configuration | Set or update the database connection for a platform |
set-tool-path |
Configuration | Set the path to a SchemaSmith tool for a platform |
clear-connection |
Configuration | Remove the database connection for a platform |
clear-tool-path |
Configuration | Remove a tool path configuration for a platform |
| Tool | Category | Description |
|---|---|---|
navigate-context |
Context Navigation | Change the current product, template, or table selection |
apply-change |
Schema Modification | Modify schema JSON files to apply changes |
create-table |
Schema Modification | Create a new table with platform-correct conventions |
rename-column |
Schema Modification | Rename a column with full cascade through indexes and FKs |
rename-table |
Schema Modification | Rename a table with cascade through FK references |
apply-generated-schema |
Schema Modification | Write generated schema tables to template directory as JSON |
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 |
| 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 |
view-log |
Log Viewing | View or open external tool log files |