Horizon Schema icon

Horizon Schema

Commercial

Professional database schema visualization and documentation tool with multi-database support and interactive diagrams

macOS

Horizon Schema

Professional database schema visualization and documentation tool that brings your database structure to life with interactive diagrams and comprehensive documentation capabilities.

Overview

Horizon Schema is a powerful desktop application designed for database administrators, developers, and data architects who need to visualize, document, and understand complex database schemas. With support for multiple database systems and rich export options, it's the perfect tool for database documentation and exploration.

Key Features

Multi-Database Support

Connect seamlessly to PostgreSQL, MySQL, SQLite, SQL Server, and AWS Redshift databases. Horizon Schema automatically detects schema structures, relationships, and constraints across different database systems.

Interactive Visualization

Navigate your database schema with an intuitive drag-and-drop interface. Zoom, pan, and arrange table diagrams to create the perfect view of your database structure. Highlight relationships and explore foreign key connections visually.

Relationship Mapping

Automatically detect and visualize foreign key relationships between tables. See at a glance how your tables connect and understand the data flow through your database.

Code Generation

Generate SQLAlchemy ORM models and pandas query code directly from your database schema. Export ready-to-use Python code that matches your database structure perfectly.

Export & Documentation

Save your schema diagrams as high-quality PNG or SVG images for documentation, presentations, or team collaboration. Create comprehensive database documentation with minimal effort.

Built with Python 3.11+ and PyQt6, Horizon Schema delivers professional-grade database visualization with responsive performance even when working with large, complex schemas.

Download

Popular

Free Download

Horizon Schema is completely free to download and use with no restrictions

$0one-time

Up to 1 user

  • All database connectivity features
  • Unlimited schema visualizations
  • Code generation (SQLAlchemy & pandas)
  • PNG and SVG export
  • No trial period or limitations
  • Free updates
  • No registration required
  • MIT License - Free to use

Key Features

Multi-Database Connectivity

Connect to PostgreSQL, MySQL, SQLite, SQL Server, and AWS Redshift. Horizon Schema automatically reads schema metadata, table structures, and relationships from any supported database system.

Interactive Table Diagrams

Drag and drop tables to arrange your schema visualization. Zoom and pan controls make it easy to navigate large database schemas. Click tables to highlight their relationships and dependencies.

Visual Relationship Mapping

Foreign key relationships are automatically detected and rendered as visual connections between tables. Understand complex data relationships at a glance with clear, intuitive relationship lines.

SQLAlchemy Code Generation

Generate complete SQLAlchemy ORM model code from your database schema. Export production-ready Python classes with proper relationships, column types, and constraints defined.

Pandas Query Builder

Create pandas DataFrame query code for reading from your database tables. Generated code includes proper connection handling and type conversions for seamless data analysis.

High-Quality Export

Save your schema diagrams as PNG or SVG images. Vector SVG export ensures your diagrams look perfect at any size, ideal for technical documentation and presentations.

Code Examples

Connect to a PostgreSQL database and visualize its schema with just a few lines of code.

from horizon_schema import SchemaVisualizer

# Connect to your database
visualizer = SchemaVisualizer()
visualizer.connect(
    engine='postgresql',
    host='localhost',
    port=5432,
    database='myapp_production',
    username='db_user',
    password='secure_password'
)

# Load schema from database
schema = visualizer.load_schema()

# Visualize the schema
visualizer.show_diagram(schema)

System Requirements

minimum

os

macOS 10.15 (Catalina) or later

Tested on macOS 14+ (Sonoma). Compatible with both Intel and Apple Silicon Macs.

minimum

runtime

Python 3.11 or later

Python 3.11, 3.12, or 3.13 required. Does not require system Python installation.

minimum

memory

512 MB RAM minimum

Recommended 1 GB+ for large database schemas with 100+ tables

minimum

storage

150 MB free disk space

Additional space needed for exported diagrams and generated code

minimum

dependency

Database drivers for target databases

PostgreSQL (psycopg2), MySQL (PyMySQL), SQL Server (pyodbc), SQLite (built-in)

recommended

network

Network access to remote databases

Required only when connecting to remote database servers. Local databases (SQLite) work offline.

Support & Resources