SchemaSmith Documentation

Ask Forge

AI-powered CLI agent and MCP server for database schema management.

Ask Forge AI-powered schema assistant

Overview

Ask Forge is an AI-powered assistant for SchemaSmith database schema management. It brings the full SchemaSmith toolchain — schema extraction, deployment, validation, migration generation, and more — into a conversational interface powered by large language models.

Built on the Forge Barrett persona — a master database craftsman — Ask Forge speaks the language of your schemas and understands the SchemaSmith ecosystem from the ground up. It works across SQL Server, PostgreSQL, and MySQL.

Two Ways to Use Ask Forge

With an LLM Provider

Connect Ask Forge to any of 11 supported LLM providers for AI-powered agentic workflows. The LLM reasons about your schema and orchestrates the 40+ tools automatically.

  • Conversational schema review and design
  • Automated migration script generation
  • Natural language queries about your database
  • Intelligent troubleshooting and recommendations
Directly via Console

Use Ask Forge without any LLM subscription. The built-in console gives you direct, hands-on access to every MCP tool in the toolkit.

  • No AI provider required
  • Direct access to 40+ schema tools
  • CLI commands: review, design, migrate, troubleshoot, learn
  • Full control over every operation

MCP Server

Ask Forge also runs as an MCP (Model Context Protocol) server, exposing its full tool suite to any MCP-compatible AI client. Use it with Claude Desktop, VS Code, Cursor, or any other MCP client.

40+ Tools

Schema nav, validation, generation, modification, and external tool execution

Resources

Schema packages, templates, tables, and a 30-article knowledge base

Prompts

Pre-built prompts for common schema design workflows

Capabilities at a Glance

Ask Forge organizes its 40+ tools into four trust tiers, from read-only exploration to full external tool execution.

Tier 1: Read-Only Tools Observer

Schema navigation, data validation (nulls, orphans, duplicates), index analysis, dependency graphing, search, and diff/compare.

View Tier 1 tools
Tier 2: Generation Tools Assistant

Migration script generation, change suggestions, schema generation from natural language, and script saving.

View Tier 2 tools
Tier 3: Modification Tools Operator

Apply changes to schema JSON, rename tables and columns, create tables and packages, manage tokens. Requires confirmation.

View Tier 3 tools
Tier 4: External Tools Admin

Execute SchemaTongs, SchemaQuench, and DataTongs against live databases for schema extraction and deployment.

View Tier 4 tools

Platforms and Providers

Database Platforms
  • SQL Server — Full support for all SchemaSmith Enterprise tools
  • PostgreSQL — Full support for all SchemaSmith Enterprise tools
  • MySQL — Full support for all SchemaSmith Enterprise tools
11 LLM Providers
Ollama OpenAI Anthropic Azure OpenAI Google Gemini Groq Mistral xAI Grok DeepSeek OpenAI-compatible Custom

Run locally with Ollama or connect to any cloud provider. Configure providers

Documentation