A single engine for dialect transpilation, query optimization, restructuring, function mapping, and syntax validation — exposed through REST APIs and deployable on-premise behind your firewall.
Pipe legacy and cloud SQL through one service: translate statements, optimize plans, split or combine queries, map functions per dialect pair, and validate before cutover.
Interactive docs at /docs and /redoc when self-hosted.
SQLForge goes beyond string replacement: CTE and join optimization, window and aggregation tuning, Teradata-style calculated fields, subquery-to-CTE conversion, query splitting, index suggestions, security scanning, and cost profiling — all callable from the same service surface as translation.
Full-statement transpilation with per-dialect function mapping. Batch endpoints for folders of SQL, plus GET-based translation for quick tests.
/translate-sql and /translate-sql-batch/map-function for single-function parity checks/validate-sql for syntax checks by dialectRewrite queries for clearer plans: CTE folding, join reordering, aggregation and window optimizations, parallel hints where applicable.
/optimize-sql with strategy optionsBreak very long SQL into maintainable pieces, combine scripts as CTE chains, and convert correlated subqueries to readable CTEs.
/sqlbreaker, /split-query/convert-subqueries-to-cte/combine-queriesDetect tables and columns from SQL text, surface calculated fields, and emit DDL-oriented hints for documentation and migration packs.
/detect-schema/detect-calculated-fieldsStatic analysis for injection patterns and risky constructs; maintenance hints and query profiling to estimate cost and bottlenecks.
Integrate legacy SAS and macro-heavy pipelines: macro transforms and SQL extraction paths that feed the same translation and lineage stack.
/sqlmacros for SAS macro processingRun SQLForge as a single process (for example uvicorn) and integrate from IDEs, pipelines, or internal portals. Same routes support interactive Swagger UI and machine clients.
/translate-sql
Translate full SQL between dialects with function mapping applied.
/translate-sql-batch
Multiple statements or files in one request for bulk migration jobs.
/supported-dialects
List source and target dialects available for the running build.
/validate-sql
Syntax validation for a chosen dialect before execution on target.
/optimize-sql
Optimization passes: CTEs, joins, aggregations, and more.
/health
Liveness for load balancers and Kubernetes probes.
Full endpoint list includes encode/decode helpers, dialect conversion, index suggestions, SQL breaking, and unified / root discovery — see OpenAPI when deployed.
SQLForge powers fine-grained lineage: column-to-column hops, transformation classification, multi-step workflows, and STTM documentation — with exports to JSON, Excel, and interactive HTML reports for catalogs and governance.
Deploy SQLForge alongside MigryX migration projects: same branding, same compliance story — no requirement to send production SQL to a third-party SaaS if your policy forbids it.
Host the FastAPI service and optional web UI inside your network. Ideal for regulated environments that need translation and lineage without cloud egress.
Optional browser UI for ad-hoc operations; teams wire the same endpoints into CI/CD for automated regression on translated SQL.
Pair the engine with MigryX SQL migration: inventory, dialect classification, pilot translations, and validation — with SQLForge as the processing backbone.