AI-powered CLI agent and MCP server for database schema management.
What if your AI assistant knew your database?
Ask Forge is an AI-powered assistant for SchemaSmith database schema management. It brings the full SchemaSmith toolchain — schema extraction, deployment, validation, migration planning, 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.
With 47 tools organized into 4 tiers, 10 LLM providers, and 3 trust levels, Ask Forge gives you full control over what the assistant can do — from read-only schema exploration to running SchemaSmith tools against live databases.
Ask Forge brings AI to your schema workflow through two integration paths — plus direct CLI access when you don't need AI at all.
Run ForgeBarrett.Mcp as an MCP server and connect it to Claude Desktop, VS Code, Cursor, or any MCP-compatible client. Your AI reasons over your schema with all 47 SchemaSmith tools — plus resources and prompts built in.
Don't use MCP? Ask Forge has its own agent with 10 LLM providers built in — Ollama, OpenAI, Anthropic, and more. Same 47 tools, self-contained.
Launch ask-forge for a persistent session. Browse schemas, run tools, and manage your database — no AI provider required. Full command history and direct control over all 47 tools.
Run any Ask Forge tool as a direct, one-off command from your terminal—ideal for scripting and automation. Use the form ask-forge <command> --product <path> [--template <name>] followed by any command-specific options. For example, ask-forge review-schema --product /path/to/MyProduct runs a full schema review, or ask-forge list-tables --product /path/to/MyProduct lists every table in your schema. Direct commands require no LLM provider—they execute, return results, and exit, making them perfect for CI pipelines and automated workflows.
Ask Forge organizes its 47 tools into four tiers, from read-only exploration to full external tool execution. Three trust levels control which tiers are accessible.
Schema navigation, data-quality checks, dependency analysis, validation, search, and diff/compare — plus platform-specific materialized and indexed view inspection.
View Read-Only toolsGenerate table JSON from a blueprint, analyze a proposed change with risk assessment, and manage database connections.
View Generation toolsApply changes to schema JSON, create and rename tables and columns, save scripts and migrations, configure data delivery, create views, and build packages. Requires confirmation.
View Modification toolsExecute SchemaTongs, SchemaQuench, and DataTongs against live databases for schema extraction, deployment, and data export. Requires confirmation.
View External toolsAsk Forge works across SQL Server, PostgreSQL, and MySQL—the same AI assistant and toolset on all three platforms. Whether you use it as an MCP server or the built-in agent, all 47 tools are available. Some tools surface platform-specific features only where they apply, like indexed views on SQL Server or materialized views on PostgreSQL.
Run locally with Ollama or connect to any cloud provider. Configure providers