AI-POWERED · ENTERPRISE READY · SQL SERVER & POSTGRES

Database Migration, Reimagined with AI

Cygenix connects to SQL Server, Azure SQL, Postgres and file sources (CSV, Excel, text) — on-premises or in any cloud. It maps your schema intelligently using Claude AI, validates results, and delivers professional reports — in minutes, not months.

Start free trial → See the platform
AI
COLUMN MAPPING
Agentive
AUTONOMOUS MIGRATION
Live
REPORTING & INSIGHTS
100%
BROWSER-BASED
🟢 Connected · Source DB · 342 tables loaded
AI mapped 47 columns in 2.3s
🤖 Agentive mode · Plan generated · 18 steps queued
📊 Reporting · Exec summary regenerated · 1 page
🔍 Data insight · "What does dbo.Transaction do?" answered
Task agent · Nightly conversion scheduled · 22:00
📦 Execution plan · 4 groups · 27 jobs
🟢 Migration complete · 0 errors
🔄 Was/Is rules applied · 312 translations
📅 Project Plan updated · 7 days to completion
📄 Conversion report exported · Excel ready
🟢 Connected · Source DB · 342 tables loaded
AI mapped 47 columns in 2.3s
🤖 Agentive mode · Plan generated · 18 steps queued
📊 Reporting · Exec summary regenerated · 1 page
🔍 Data insight · "What does dbo.Transaction do?" answered
Task agent · Nightly conversion scheduled · 22:00
📦 Execution plan · 4 groups · 27 jobs
🟢 Migration complete · 0 errors
🔄 Was/Is rules applied · 312 translations
📅 Project Plan updated · 7 days to completion
📄 Conversion report exported · Excel ready
Everything you need to
migrate with confidence
🤖
Agentive Migration NEW
Two ways to run a job. AI-Assisted — Cygenix recommends, you approve each step. Agentive — full autonomous execution end to end, with checkpoints and a human-in-the-loop kill switch.
📊
Reporting
Interactive BI dashboards over your source or target database, drag-and-drop chart builder, and the home for auto-generated executive project summaries and conversion reports — ready to email to stakeholders. Upload context documents (emails, client briefs, sign-offs, Was/Is mappings, data dictionaries, schema docs) and Claude reads them when generating narratives, with inline citations back to the source (e.g. [Email, 14 Apr]).
🔍
Data Insights
Understand any database in plain English. Ask "what does this table do?", "where is config held?", "which tables hold financial data?" — Cygenix reads the schema, samples the data and answers you naturally. Onboard a legacy database in hours, not weeks.
Task Agent
Job scheduler for everything Cygenix does. Run conversions, validations, reindexes and reports on a schedule — once, daily, weekly or cron. Job chains, retry policies, email alerts. Set it and walk away.
🔌
Connect to Anything
Live database connections to SQL Server (on-prem, Azure SQL, Azure Managed Instance, AWS RDS, Google Cloud SQL) and PostgreSQL (self-hosted, RDS, Aurora, Azure Database, Cloud SQL, Supabase, Neon). File sources for .csv, .xlsx, .tsv and .txt — multi-sheet workbooks handled. Cross-engine migration in any direction, with a built-in DDL generator that creates target tables from the source schema and flags lossy conversions (jsonb, arrays, hierarchyid). Azure Function with Managed Identity also supported.
🤖
AI Column Mapping
Claude AI maps every source column to its target automatically, with a colour-coded confidence score per row. Switch between the table view (target-driven layout, source dropdown per column, fixed value override, truncation warnings) and the visual view (drag-and-drop pills with bezier connection lines, fullscreen for complex jobs). One-to-many mode maps a single source into multiple target tables in one operation.
🔄
Was/Is Translation & System Parameters
Upload translation tables to convert values during migration — status codes, lookup IDs, department names, currency codes, and more. Define @@Tokens once and use them across SQL, Was/Is rules, WHERE clauses, literal mappings and custom jobs — values substitute at runtime. CSV / JSON import and export, filter and sort.
Flexible Validation
Add any table as a validation source. Pick which column holds the SQL, choose which columns appear in the report. Run any number of validation tables against any database.
📦
Grouped Execution Plans
Organise jobs the way an enterprise migration actually runs — group by concern (Static Config, Masters, Transactions), drag jobs between groups, pick sequential or parallel per group. Tick-box selection runs only what you need.
📅
Project Planner
Full calendar (year/month/week/day views), task tracking, blocker management, execution phase tracker, and activity log — driven by your project completion date.
🔗
Integrations
Sync your migration plan with the tools your team already uses. Bidirectional, field-mapped sync with Atlassian Jira and Smartsheet for issue tracking — import existing issues, push new tasks, full sync history. Credentials stay in your browser.
💻
SQL Editor
Full-featured SQL editor with script library, connection selector, find & replace, results grid, history, AI assistant, and one-to-many mapper for complex transformations.
🧹
Data Cleansing
Find near-duplicate rows in a source table before migration. Pick the columns to match on and a strategy per column — exact, fuzzy, phonetic or numeric. Review candidate clusters, optionally have Claude review ambiguous ones for false positives, then export to CSV/JSON or generate merge SQL. Detection-only — your data stays untouched until you decide to act on it.
🔐
Secure by Design
Authentication via Azure Entra External ID with SSO and Google sign-in. Azure Managed Identity supported, role-based access, full audit trail of every action. UK GDPR compliant. Database credentials live in your browser, not on our servers — sent only when running queries.
🖧
Server Migration NEW
Move the server-level objects most tools leave behind. Logins migrate with hashed passwords and SIDs preserved (database users stay mapped). SQL Agent jobs travel with their steps, schedules, categories and operators. SSIS projects deploy server-to-server via the catalog — environments, variables and references included. Linked servers reproduce the exact provider and options from source. Verify, discover, preview, execute, audit — one flow.
Target-driven mapping
with AI confidence
Every target column shown as a fixed row. Source column, fixed value override, truncation warnings and AI confidence — all in one place.
Simple Map
One table to one table, mapped in seconds
Select source and target tables. Claude AI maps every column automatically. Override any row, add a fixed SQL value, hide unmapped columns, filter by match confidence.
  • Target-driven layout — every target column shown, source is a dropdown
  • ✦ Visual mode — drag-and-drop pill view with connection lines and fullscreen
  • Fixed value column — type any SQL literal (N'Value', NULL, GETDATE())
  • ⚠ Truncation warnings when source char type is wider than target
  • 👁 Show/Hide Unmapped toggle to focus on what matters
  • AI uses Haiku with automatic retry on overload
Object Mapping · Simple Map
👁 Hide Unmapped
Source col
Src type
Target col ▲
Fixed value
Match
✓ 15 columns mapped · 2 hidden (unmapped)
INSERT INTO [TargetDB].[dbo].[effective_dated_records]
SELECT [run_number], [code], LEFT([description_text], 100), N'Enterprise', [active_flag]
FROM [SourceDB].[dbo].[effective_dated_records]
Visual Mapping
See the whole schema at once
Switch from the table view to a drag-and-drop pill view. Source columns left, target columns right, connection lines fanning across — colour-coded by AI confidence. Fullscreen mode expands the canvas to your full window for complex jobs.
  • Drag any source pill onto a target to create the mapping
  • Bezier connection lines redraw on every scroll and resize
  • Click a line (or the ✕ on a target pill) to remove the mapping
  • Green / amber / red / grey pills — HIGH / MEDIUM / LOW / unmapped
  • ⛶ Fullscreen toggle expands to the full browser window; Esc to exit
  • Bidirectional state sync with the Table view — switch any time
👉 Try it — drag a source pill onto a target, or click a line to remove it
Object Mapping · Visual view
⛶ Fullscreen
5 mapped · drag to add more
One-to-Many Map
One source, multiple target tables
Map a single source table into multiple target tables in one operation. Each target card has its own AI mapping, filter, hide-unmapped toggle, FK relationships and fixed values.
  • Add as many target table cards as needed
  • PK mode per card — Identity, GUID or natural key
  • FK columns reference PK variables from parent cards
  • AI maps each card independently with overload retry
  • Single generated SQL script covers all target tables
Object Mapping · One-to-Many · 3 target tables
dbo.ClientMaster 5 mapped 🤖 AI map 👁 Hide Unmapped
PK: Identity · @ClientID · 5 cols mapped
dbo.ClientAddress 4 mapped 🤖 AI map
PK: GUID · FK → @ClientID
dbo.ClientContact 3 mapped 🤖 AI map
PK: Identity · FK → @ClientID
The objects most tools leave behind.
Schema and data are only half a migration. Logins, jobs, SSIS packages, linked servers — these live at the server level and almost every other tool either ignores them or makes you script them by hand. Cygenix moves them in a single, auditable flow.
  • Logins — hashed passwords and SIDs preserved, so existing database users stay correctly mapped on the target. Server roles and Windows groups included.
  • SQL Agent jobs — full dependency graph migrated: steps, schedules, categories, notification operators. Jobs created disabled by default so nothing fires unexpectedly on the target.
  • SSIS packages — project deployment model. .ispac binaries transferred server-to-server via the catalog API; environments, variables and parameter overrides included; SSISDB auto-created on target if missing.
  • Linked servers — provider, datasource and server options reproduced exactly, regardless of provider type. Remote passwords supplied per server (SQL Server cannot read them back from source).
  • Five-step shell: Verify → Discover → Preview → Execute → Audit. Sysadmin check on both sides, full SQL preview with redacted secrets, downloadable JSON audit trail of every action.
  • Already-existing items skipped via IF NOT EXISTS guards. Re-runs are safe.
Server Migration · Step 4 of 5 · Execute
1 Verify ✓
2 Discover ✓
3 Preview ✓
4 Execute
5 Audit
LOGIN app_service CREATED
LOGIN reporting_user CREATED
JOB Nightly_DataRefresh CREATED · 4 steps
JOB Old_BackupCheck SKIPPED
PROJ Finance/SalesETL DEPLOYED
ENV Finance/Production 12 vars
LINK LINK_REPORTING CREATED
Progress: 47 / 52 ✓ 41 – 5 ✕ 1
Any table. Any SQL. Any database.
No longer locked to a fixed schema or table name. Add any table as a validation source, pick which column holds the SQL to execute, choose which columns appear in the failure report, and run against any database.
  • Add multiple validation tables from different connections
  • Pick the SQL column, name column and report columns per source
  • Run all, run selected (checkboxes), or run one source at a time
  • Inline result rows shown with your chosen report columns
  • Export to Excel — summary + one sheet per failed script
  • ⏹ Stop mid-run at any time
Data Validation · 3 sources
Post-migration checks
Table: dbo.PostMigrationChecks · SQL col: CheckSQL · 24 scripts
3 fail 21 pass
Financial integrity checks
Table: dbo.FinancialChecks · SQL col: CheckQuery · 8 scripts
8 pass
✓ Pass: 0 ✕ Fail: 0 ⏳ Pending: 0
Project Plan · Calendar — April 2026
Year
Month
Week
Day
◀ April 2026 ▶
M
T
W
T
F
S
S
7
days left
12
done
3
in progress
1
blocker
Plan, track and deliver your migration
A full project management tool built into Cygenix. Calendar views, task tracking, blockers, phase progress and activity log — all driven by your project completion date from Project Settings.
  • Year / Month / Week / Day calendar views — click to add events
  • Outlook-style event modal with type, time, location, attendees
  • Task table with status, priority, phase, owner and due date
  • Blocker management with impact level and resolution tracking
  • 7-stage execution phase tracker — click to set current phase
  • 🔗 Jira & Smartsheet sync — bidirectional, field-mapped, full sync history
  • Activity log records every change automatically
Full-featured SQL workspace
Write, save, run and manage SQL scripts against source or target databases. AI assistant, find & replace, history, results grid with pivot view and Excel export.
  • Script library — save, name and load any number of scripts
  • Ctrl+Enter to run, Ctrl+F to find, Ctrl+/ to comment selection
  • Results grid with row / pivot view and Excel export
  • Query history with re-load and timestamp
  • AI assistant — describe what you need, Claude writes the SQL
  • Snippet toolbar — SELECT, WHERE, INSERT, UPDATE, TRAN
SQL Editor · Source DB
-- Count records by status for reconciliation
SELECT
  [status_code],
  COUNT(*) AS record_count,
  SUM([amount]) AS total_amount
FROM [dbo].[transactions]
WHERE [created_date] >= '2024-01-01'
  AND [active_flag] = 1
GROUP BY [status_code]
ORDER BY record_count DESC
▶ Run (Ctrl+Enter) |🔍 Find|⬇ Export
status_code
record_count
total_amount
ACTIVE
1,842
£2,341,990
PENDING
234
£89,450
CLOSED
89
£12,100
✓ 3 rows · 12ms
AI-Assisted or fully Agentive —
you choose how much to hand over
Cygenix offers two ways to run a migration. AI-Assisted keeps you in control with intelligent suggestions at every step — think of it like the driver-assist features in a modern car. Agentive Migration lets Cygenix plan and execute the whole job autonomously while you supervise — closer to a self-driving experience. Both modes give you the kill switch.
🚗
AI-Assisted Migration
YOU DECIDE · AI ASSISTS
Like adaptive cruise and lane-keep — you stay in the driver's seat, the AI keeps you on track and warns you before trouble.
  • AI suggests every column mapping; you review and approve
  • You click Run on each phase — load, validate, reconcile
  • Cygenix flags risks ahead — truncation, FK gaps, slow queries
  • You decide when to retry, skip, or roll back
  • Best for first-time migrations, regulated workloads, demos
🤖
Agentive Migration
FULLY AUTONOMOUS · YOU SUPERVISE
Like full self-driving — the agent plans the route, executes every step, handles obstacles, and pulls over only if it can't safely continue.
  • Plans the entire migration — extract, map, load, validate
  • Executes phases end-to-end with retries and back-off
  • Self-heals on transient errors; pauses on data anomalies
  • Streams progress — you see every action in the activity log
  • Hit ⏸ Pause or ⏹ Kill at any time — full rollback supported
Migration Run · Agentive mode · Phase 3 of 6
Mode:
AI-Assisted
🤖 Agentive
RUNNING
✓ Connect
✓ Map
⟳ Load
Validate
Reconcile
Report
[12:04:21] ✓ Connected to source · 342 tables discovered
[12:04:38] ✓ AI mapping complete · 47 columns · 2 truncation warnings auto-resolved
[12:05:02] ⟳ Loading dbo.Transaction · batch 8/24 · 5,000 rows/sec
[12:05:14] ⚠ Transient timeout on dbo.Voucher — retrying with back-off (1/3)
[12:05:19] ✓ Recovered · continuing
The home for business intelligence,
not just migration logs
Reporting is where Cygenix turns raw migration data into something you can act on. Build interactive BI dashboards over your source or target database with drag-and-drop charts. Auto-generate executive project summary documents and conversion reports — written in plain English, ready to send to stakeholders.
  • Interactive BI dashboards — bar, line, pie, donut, heatmap, KPI tiles, pivot tables
  • Drag-and-drop chart builder — point at any table or query, drop dimensions and measures, done
  • Cross-filter — click any segment in any chart to filter every other chart on the page
  • Executive Project Summary — one-click AI-generated narrative document covering scope, progress, risks and next steps
  • Conversion Reports — every migration run produces a polished, branded report (Excel + PDF) with full lineage
  • Schedule any report to email itself to stakeholders weekly or on milestone completion
  • Drill-through from any chart straight into the SQL Editor for the underlying query
Reporting · BI Dashboard · Sample Project
⬇ Export
📊 BI Dashboard
📄 Exec Summary
📑 Conversion Report
+ Add chart
Total Revenue
£4.82 M
▲ 12.4% YoY
Active Accounts
1,847
▲ 86
Avg Cycle Time
42 d
▼ 3.1 days
Margin
87.2%
— stable
Revenue by category
↗ drill through
Cat A
Cat B
Cat C
Cat D
Cat E
Cat F
Cat G
Other
Invoiced vs collected · last 12 months
Invoiced Collected
Accounts by region
1.8K
accounts
UK · 46%
EU · 25%
US · 16%
APAC · 13%
Reporting · Executive Project Summary · auto-generated
✨ Regenerate
Project Status Report · 2 May 2026
ERP Data Migration — Phase 3 of 4
● ON TRACK 2 risks open Go-live: 11 Jun 2026
Executive summary. The data conversion is progressing on schedule, with 14 of 19 in-scope tables fully migrated and reconciled. Validation pass rate is holding at 98.7%, ahead of the 97% target. Two open issues remain in the financial domain and are being tracked.
Progress this week. Completed Transaction, TransactionDetail and Invoice loads (2.4M rows). Validation suite ran clean on all three. Cutover rehearsal scheduled for 28 May.
Risks & next steps. Customer master requires a manual reconciliation pass before final load. Business team availability for UAT remains the critical-path dependency.
Generated by Cygenix · 2 May 2026 · 09:14 📄 Export PDF · 📧 Email stakeholders
Executive Summary & Conversion Reports
From raw run logs to a board-ready document — automatically
Cygenix reads the full state of your project — completed phases, open risks, validation results, blockers, timeline — and writes a polished one-page status report for executives. Conversion reports give the technical team the full lineage, every mapping decision, every Was/Is rule applied, every row count.
  • Executive Project Summary — narrative status report, regenerated on demand
  • Conversion Report — full audit trail of every migration run, signed off and timestamped
  • Branded templates — your logo, your colours, your headers
  • Schedule weekly delivery to your steering committee, in their inbox, no copy-paste
  • PDF, Word and Excel formats — no special viewer required
Data Insights
Understand any database
in plain English
Connect to a database you've never seen before and ask Cygenix what's in it. "What does this table do?" "Where is configuration held?" "Which tables hold financial data?" Cygenix reads the schema, samples the data, and answers in plain English — so you stop guessing and start understanding.
  • Ask questions in natural language — no SQL knowledge required
  • Auto-generated table summaries — purpose, key columns, what each row represents
  • Smart classification — finds config, lookups, transactions, audit, financial, security tables
  • Column-level descriptions inferred from names, types, samples and FK relationships
  • Domain mapping — see how tables connect into clusters (Customers, Orders, Finance, Inventory)
  • Every answer cites the tables, columns and sample values it's based on
  • Especially powerful on legacy or undocumented databases — onboard in hours, not weeks
Data Insights · Ask anything about your database
👤
What does dbo.Transaction do?
Transaction stores financial transaction header records — one row per outgoing payment. Each row captures who was paid, the amount, the originating account and the posting period. It links to TransactionDetail for line-level breakdowns and Counterparty for the recipient.
domain: Financial ~ 2.4M rows 28 cols PK: TransactionId
👤
Which tables hold financial data?
Found 14 tables with financial data, grouped into three clusters:
Payments Transaction, TransactionDetail, Voucher, +2
Receivables Invoice, InvoiceLine, AccountBalance, +1
Ledger Journal, Balance, Period, +1
👤
Where is the system configuration held?
SystemSetting holds key-value runtime settings (78 entries). FeatureFlag stores per-module flags. Lookup codes live in LookupCode and its 23 child tables (e.g. CurrencyCode, StatusCode).
Ask another question… ✨ Ask
Task Agent · Schedule · 6 jobs queued
+ New Job
⏰ Upcoming
📜 Run history
⚙ All jobs
02 May
22:00
Nightly conversion · Sample Project
Full run · 19 tables · ~ 4h 20m
Daily in 6h 12m
03 May
06:00
Validation suite · post-conversion
32 scripts · email report on completion
Daily scheduled
04 May
02:00
Reindex Transaction + Customer
Maintenance · target DB only
Sun weekly scheduled
05 May
09:00
Weekly executive summary email
to: project-stakeholders@example.com
Mon weekly scheduled
11 Jun
23:00
Go-live cutover run
Full migration · production target
Once scheduled
Last run
01 May
22:00
Nightly conversion · Sample Project
2.41M rows · 4h 06m · 0 errors
Daily ✓ success
Job scheduler — set it and walk away
Cygenix isn't just for live runs. Schedule any conversion, validation suite, reindex, report or custom SQL job to run at a specific time, on a recurring cadence, or after another job completes. The Task Agent picks it up, runs it, and emails you when it's done.
  • One-time, daily, weekly, monthly or custom cron schedules
  • Schedule any job type — full conversion, single table, validation, reindex, report, custom SQL
  • Job chains — "run B only when A succeeds" with up to 10 dependencies
  • Email notifications on success, failure or both
  • Built-in retry policy — pick attempts, back-off and timeout per job
  • Full run history with logs, row counts and timing — keep, replay or branch from any past run
  • Pause an entire schedule with one click for go-live freezes or maintenance windows
Tuned for your environment
Quick presets for common scenarios. Fine-tune batch sizes, timeouts, concurrency and data loading to match your server's capacity. Import and export settings as JSON.
Small DB
1,000 rows/page
1 thread
Full verify
Medium DB
2,000 rows/page
2 threads
Balanced
Large DB
5,000 rows/page
4 threads
NOLOCK
Azure SQL
90s connect
5 retries
DTU-safe
Cautious
100 rows/batch
1 thread
Row verify
Ready to migrate
with confidence?
Cygenix handles the complexity — AI column mapping, AI-Assisted and fully Agentive migration modes, interactive BI reporting with auto-generated executive summaries, plain-English data insights, scheduled jobs, cross-engine migration, file imports, validation, dedup detection, project planning, integrations with Jira and Smartsheet, and AI report narratives grounded in your project documents — so your team can focus on the migration, not the tooling.
Start free trial → Read the docs