SQL Power Architect

SQL Power Architect is a free desktop application for data modeling, profiling, and warehouse schema design. It is aimed at data architects, DBAs, analysts, and designers working across existing databases, especially when lineage and OLAP structures matter. Its broad modeling toolkit is most attractive to teams that can run Java 8 and work within a desktop, JDBC-based setup.

Overview

Architect supports reverse engineering of existing databases and forward engineering for Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2, HSQLDB, H2, and Derby, with SQL export for supported systems. JDBC connections can remain open to multiple source databases concurrently, which suits warehouse projects assembled from several systems.

The desktop deployment works on Linux, macOS, and Windows. Projects preserve source-structure snapshots, allowing design work away from live connections. That is useful for remote or disconnected work, although organizations wanting a browser-first workflow should consider another tool. The project format is XML and described as easy to parse, while the GPL-3.0 license permits use without a purchase.

Key features

Modeling and engineering

Reverse engineering turns existing schemas into models, while forward engineering takes designs back toward database implementation. Model and structure comparison identifies discrepancies, giving teams a practical way to review changes between designs and databases instead of checking them manually.

Lineage and profiling

Architect remembers each column's origin and generates visual source-to-target mapping reports. That makes it more suitable for documenting warehouse pipelines than a diagram-only utility. Profiling reports column size, minimum and maximum values, and frequency distributions, helping analysts inspect source quality before committing to a design.

OLAP schemas

Its OLAP modeling covers cubes, measures, dimensions, hierarchies, and levels. This is a meaningful advantage for dimensional-warehouse planning, but less relevant if your work is limited to simple transactional diagrams.

Drivers and runtime

Downloads list preconfigured JDBC drivers for PostgreSQL 8.2, SQL Server 2012, MySQL 5.0, and HSQLDB 1.8.0. The listed packages require Java Runtime 8; the Mac package specifies OS X 10.4 or newer. Check those versions against your systems before standardizing on the tool.

Pricing

Community Edition: free, GPL v.3 licensed, with Java Runtime 8 required for the listed downloads. There are no paid tiers or seat charges described, so it fits individual practitioners and teams seeking a no-cost desktop modeler. The trade-offs are the Java-based runtime, desktop deployment, and the need to verify driver compatibility rather than choosing among service plans.

Platforms

SQL Power Architect runs on Linux, macOS, and Windows. The download page offers Windows and Mac OS X installers plus a Unix/Generic command-line download. The release page identifies version 1.9.0, described in its notes as Community Edition 1.0.9 with Java 8 support.

Who it's for

Choose it for data-warehouse architects, DBAs, analysts, and designers who need concurrent JDBC connections, schema comparison, profiling, lineage reports, and OLAP concepts in one free application. It is a weaker fit for teams that require a browser-based shared workspace, newer bundled driver versions, or a non-Java runtime.

Pros and cons

• Pro: Free GPL-3.0 licensing removes subscription and seat costs.
• Pro: Reverse and forward engineering spans major relational systems and includes SQL export.
• Pro: Column lineage, mapping reports, profiling, and OLAP objects address warehouse-specific work.
• Pro: Snapshots support offline or remote modeling without a live source connection.
• Con: The desktop-only approach does not suit browser-centered collaboration.
• Con: Java 8 and older bundled driver versions can require environment checks before deployment.

Alternatives

Browse more options in Database Design Tools. Pick Hackolade Studio instead if you want Linux, macOS, web, and Windows coverage with a freemium model and a 50-object Community Edition cap. MySQL is the better choice when you need a database platform with SQL and NoSQL applications, replication, high availability components, and connectors. Choose DbSchema for design-file saving and schema synchronization in its Pro plan. pgModeler suits PostgreSQL-focused users comparing single-user or team subscriptions. Schemity is preferable for browser-based schema design and link sharing, with a free Lite plan. ChartDB fits self-hosted or web use when a free tier's one-user, one-database, and diagram limits are acceptable. Database Workbench offers Basic, Professional, and Enterprise editions for Linux and Windows. DB Designer is a web option with a free Starter plan capped at two models and ten tables per model.

Verdict

SQL Power Architect is a strong choice for warehouse professionals who want broad database engineering, lineage, profiling, and OLAP modeling without a license bill. Look elsewhere if browser collaboration, current driver stacks, or freedom from Java 8 is more important than its unusually complete free desktop feature set.