This page's audience our own tag's counts — open to see them

Period

–Visits

–Page views

–Clicks to vendors

–Time on page

–Reading now

Clicks to vendors, by tool

Top countries

Devices

– · visits, page views and clicks counted by our own tag, which counts more than our checked analytics; every figure rounded down · how we count

SQL Power Architect

Free#18 of 34 in Database Design Tools

SQL Power Architect: A free open-source choice for cross-database profiling, modeling, and engineering. Ranked #18 of 34 in Database Design Tools by our editors (7.6/10); pricing: Free plan; best for free cross-database profiling and modeling.

7.6/10Editor score

Visit site

SQL Power Architect7.6 Visit site

At a glance

Editor score
7.6 / 10
Pricing
Free plan
Best for
Free cross-database profiling and modeling
Free plan
Yes
Paid from
Free
Reverse engineering
Yes
Facts checked
22 Sep 2026

Where it wins
- Connects concurrently to multiple source databases for profiling
- Supports reverse engineering, forward engineering, and DDL generation
- Exports reports and profiling data in PDF, HTML, and CSV
Where it doesn't
- Desktop deployment limits it to Windows and macOS
- Integration is specifically centered on Pentaho Data Integration
- Collaboration and version-history workflows are not documented features

Our verdict on SQL Power Architect

SQL Power Architect is a desktop Java application for database modeling, source-data profiling, and data-warehouse design. It is suited to database professionals who need to inspect several relational sources, map schemas and relationships visually, and generate target database structures or ETL templates. The project is open source under GPL-3.0 and supports Windows and macOS desktop deployment.

Its strongest capability is the connection between profiling and engineering. Users can connect concurrently to multiple source databases, explore profile results, place schemas, tables, and columns in a visual modeling workspace, and reverse-engineer existing databases. The same workflow supports forward engineering, DDL generation, database structure comparison, and synchronization scripting. This makes it a practical fit for warehouse planning and cross-database analysis without a paid plan structure.

SQL Power Architect also extends its modeling workflow into Pentaho Data Integration through ETL template generation. Reports and profiling data can be exported as PDF, HTML, or CSV, while documented database support includes Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2, HSQLDB, H2, and Derby. The tradeoff is a desktop-oriented workflow rather than a broader shared workspace: teams seeking documented collaborative editing or version-history workflows should consider an alternative built around those needs. Choose SQL Power Architect for free, open-source profiling and database engineering; choose elsewhere when team collaboration is the primary requirement.

Your product? Our editors can test SQL Power Architect in depth and publish a review, labelled as paid · from $149/mo →

SQL Power Architect pricing

Plans Free planFree Free to use — no paid tier required for the core job.

See plans on github.com

SQL Power Architect fact sheet

Free plan	Yes
Paid from	Free
Reverse engineering	Yes
Forward engineering	Yes
SQL export	Yes
Supported databases	Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2, HSQLDB, H2, Derby
Team collaboration	Not verified
Version history	Not verified
Deployment	Desktop
Deployment	Desktop
Platforms	Windows, macOS
Support	Docs
Built for	Small business, Mid-market (editorial estimate)
Integrations	1 integrations: Pentaho Data Integration
Pricing	Free plan
Website	github.com
Facts checked	22 Sep 2026

SQL Power Architect integrations

SQL Power Architect lists 1 integrations on its own site.

Pentaho Data Integration

Alternatives to SQL Power Architect

See all SQL Power Architect alternatives →

Used SQL Power Architect? Be the first to review it

The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used SQL Power Architect for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.

Write a reviewTwo minutes · verified accounts only · read by an editor before it appears

Reviews come only from verified accounts. Sign in or create an account first — your e-mail is never shown.

Title

Your review

0 characters · at least 80, up to 3,000

Pros (optional · one per line)

Cons (optional · one per line)

Your name (shown with your review)

Role (optional)

Company (optional)

How long have you used it?

I've used SQL Power Architect myself and this is my honest opinion — nobody paid or asked me to write it.

Posted from your verified account. Reviews appear after an editor reads them, usually within two working days.

Featured on iTechGuides

SQL Power Architect is listed in our Database Design Tools directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/sql-power-architect/"><img src="https://www.itechguides.com/best/badge/sql-power-architect.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated 7 Oct 2026 · How we research and update