Skip to content
SPECIFICTION
Get listed

SQL Power Architect

github.com

Free plan WindowsmacOSLinux
Visit github.com
Spec score 7.4 #24 of 35 in Database Design Tools

Spec sheet

Purpose
SQL Power Architect is a data modeling and profiling tool created for data warehouse designers.Read 9 Oct 2026 · bestofbi.com
Intended users
The product page identifies data architects, DBAs, analysts, and designers as users of the tool.Read 9 Oct 2026 · bestofbi.com
License
The GitHub repository identifies the project license as GPL-3.0.Read 9 Oct 2026 · github.com
Data profiling
Profiling shows column data size, maximum and minimum values, and value frequency distributions.Read 9 Oct 2026 · bestofbi.com
Database connections
It accesses source databases via JDBC and can connect to multiple source databases concurrently.Read 9 Oct 2026 · bestofbi.com
Download platforms
The download page offers installers for Windows and Mac OS X and a Unix/Generic command-line download.Read 9 Oct 2026 · bestofbi.com
ETL metadata
It remembers the origin of each column and generates source-to-target visual mapping reports.Read 9 Oct 2026 · bestofbi.com
File format
Project data is stored in an XML format described as easy to parse.Read 9 Oct 2026 · bestofbi.com
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.Read 9 Oct 2026 · bestofbi.com
Model comparison
It compares data models and database structures and identifies discrepancies.Read 9 Oct 2026 · bestofbi.com
Offline work
It saves source data structure snapshots in projects so users can work remotely or design models offline.Read 9 Oct 2026 · bestofbi.com
OLAP
Its OLAP schema modeling covers cubes, measures, dimensions, hierarchies, and levels.Read 9 Oct 2026 · bestofbi.com
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.Read 9 Oct 2026 · github.com
Reverse engineering
It can reverse-engineer existing databases and forward- and reverse-engineer PostgreSQL, Oracle, MS SQL Server, and other databases.Read 9 Oct 2026 · bestofbi.com
Runtime requirement
The listed downloads require Java Runtime 8; the Mac download also specifies OS X 10.4 or greater.Read 9 Oct 2026 · bestofbi.com

Plans and prices

Community Edition Free GPL v.3 licensed · Java Runtime 8 required for listed downloads Read 9 Oct 2026 · bestofbi.com

Every SQL Power Architect plan and price →

Where Specifiction places it

Alternatives to SQL Power ArchitectAll alternatives →