EVERYTHING XIAOMI
Get listed

SQL Power Architect

SQL Power Architect is a data modeling and profiling tool created for data warehouse designers.

Place
#22 of 35
Score
6.1
SQL Power Architect's website

What SQL Power Architect is

SQL Power Architect is a data modeling and profiling tool created for data warehouse designers. It can connect to multiple source databases concurrently through JDBC, reverse-engineer existing databases, and support forward engineering. Its listed database support includes Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2, HSQLDB, H2, and Derby. Users can compare data models with database structures to identify discrepancies. The tool records column origins and creates visual source-to-target mapping reports, while profiling displays column size, minimum and maximum values, and frequency distributions. Projects can retain snapshots of source structures for offline design or remote work. OLAP schema modeling covers cubes, measures, dimensions, hierarchies, and levels; project data is stored in XML. The free Community Edition is identified as GPL-3.0 licensed. Listed downloads require Java Runtime 8; the Mac download also specifies OS X 10.4 or later. Download options include Windows and Mac installers and a Unix/Generic command-line download. Bundled JDBC drivers are listed for PostgreSQL 8.2, SQL Server 2012, MySQL 5.0, and HSQLDB 1.8.0.

Good

  • Connects to multiple databases concurrently via JDBC
  • Compares models with database structures
  • Profiles column sizes, values, and frequencies
  • Supports offline modeling with source snapshots
  • Models OLAP cubes and dimensions

Watch out

  • Listed downloads require Java Runtime 8
  • Mac download specifies OS X 10.4 or later
  • Bundled drivers are listed for four database versions

Who it suits

SQL Power Architect suits data architects, DBAs, analysts, and designers working with database models or warehouse schemas. Its profiling, comparison, and offline snapshot features may be useful for teams examining multiple source databases.

Verdict

SQL Power Architect covers modeling, profiling, comparison, and OLAP schema work across a range of databases. Its free Community Edition requires Java Runtime 8 for the listed downloads.

Plans and prices

From SQL Power Architect's own pricing page, checked 9 Oct 2026.

All about pricing
PlanPriceWhat it gives you
Community EditionFreeGPL v.3 licensed · Java Runtime 8 required for listed downloads

The facts

Each one read from SQL Power Architect's own pages, with the date it was checked.

What it does

Database connections
It accesses source databases via JDBC and can connect to multiple source databases concurrently.checked 9 Oct 2026
Data profiling
Profiling shows column data size, maximum and minimum values, and value frequency distributions.checked 9 Oct 2026
ETL metadata
It remembers the origin of each column and generates source-to-target visual mapping reports.checked 9 Oct 2026
File format
Project data is stored in an XML format described as easy to parse.checked 9 Oct 2026
Included JDBC drivers
The download page lists bundled, preconfigured JDBC drivers for PostgreSQL 8.2, MS SQL Server 2012, MySQL 5.0, and HSQLDB 1.8.0.checked 9 Oct 2026
Intended users
The product page identifies data architects, DBAs, analysts, and designers as users of the tool.checked 9 Oct 2026
License
The GitHub repository identifies the project license as GPL-3.0.checked 9 Oct 2026
Model comparison
It compares data models and database structures and identifies discrepancies.checked 9 Oct 2026
Offline work
It saves source data structure snapshots in projects so users can work remotely or design models offline.checked 9 Oct 2026
OLAP
Its OLAP schema modeling covers cubes, measures, dimensions, hierarchies, and levels.checked 9 Oct 2026
Purpose
SQL Power Architect is a data modeling and profiling tool created for data warehouse designers.checked 9 Oct 2026
Release status
The GitHub release page lists version 1.9.0, whose notes identify the software release as Community Edition 1.0.9 and say it supports Java 8.checked 9 Oct 2026
Reverse engineering
It can reverse-engineer existing databases and forward- and reverse-engineer PostgreSQL, Oracle, MS SQL Server, and other databases.checked 9 Oct 2026
Runtime requirement
The listed downloads require Java Runtime 8; the Mac download also specifies OS X 10.4 or greater.checked 9 Oct 2026

Where it runs

Download platforms
The download page offers installers for Windows and Mac OS X and a Unix/Generic command-line download.checked 9 Oct 2026

Alternatives to SQL Power Architect

All alternatives
  1. 1MySQL logo

    MySQL

    Free planAPILinuxmacOSSelf-hosted
    7.9Free plan
    Visit
  2. 2Hackolade Studio logo

    Hackolade Studio

    Free planWebAPILinuxmacOS
    7.8Free plan
    Visit
  3. 3

    Schemity

    Free planWebAPILinuxmacOS
    7.7Free plan
    Visit
  4. 4

    Database Workbench

    Free planLinuxmacOSWindows
    7.5€199 one-time
    Visit
  5. 5DbSchema logo

    DbSchema

    Free planLinuxmacOSWindows
    7.0From $29.40 a month
    Visit
  6. 6

    pgModeler

    Free planLinuxmacOSWindows
    6.9From $59.90 a month
    Visit