Merisio

A modern MERISE database modeling tool built with Python and PySide6.

Create MCD (Conceptual Data Model) diagrams, automatically generate MLD (Logical Data Model) views, and export PostgreSQL SQL scripts — from the GUI or the command line.

MCD Editor

Download

Download Latest Release

Available formats:

All packages include both the GUI application (merisio) and the CLI tool (merisio-cli).

Features

MCD Editor

CLI Tool (merisio-cli)

Data Dictionary

MLD View

SQL Generation

Project Management

Installation

Linux (Debian/Ubuntu)

sudo dpkg -i merisio_1.3.1_amd64.deb

This installs both /usr/bin/merisio (GUI) and /usr/bin/merisio-cli (CLI).

Linux (Portable)

tar -xzvf Merisio-linux-x64.tar.gz
cd Merisio-linux-x64
./Merisio        # GUI
./merisio-cli    # CLI

Windows

Extract Merisio-windows-x64.zip and run Merisio.exe (GUI) or merisio-cli.exe (CLI).

From Source

git clone https://github.com/AchrafSoltani/Merisio.git
cd Merisio
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
python main.py       # GUI
python cli.py        # CLI

CLI Usage

merisio-cli <file.merisio> <command> [options]
Command Description
info Show project metadata and statistics
validate Validate the MCD model (exit code 1 on errors)
sql Generate PostgreSQL DDL
mld Show the logical data model
export Export diagram to PNG, SVG, or PDF

Examples

# Project info
merisio-cli project.merisio info

# Validate (useful in CI — fails with exit code 1)
merisio-cli project.merisio validate

# Generate SQL
merisio-cli project.merisio sql
merisio-cli project.merisio sql -o schema.sql

# View MLD tables
merisio-cli project.merisio mld

# Export diagram
merisio-cli project.merisio export --format png -o diagram.png
merisio-cli project.merisio export --format svg -o diagram.svg
merisio-cli project.merisio export --format pdf -o diagram.pdf
merisio-cli project.merisio export --format png -o diagram.png --scale 3.0

Keyboard Shortcuts

Shortcut Action
Ctrl+N New Project
Ctrl+O Open Project
Ctrl+S Save Project
Ctrl+1 Dictionary Tab
Ctrl+2 MCD Tab
Ctrl+3 MLD Tab
Ctrl+4 SQL Tab
Delete Delete Selected
Ctrl+Scroll Zoom In/Out
Ctrl++ Zoom In
Ctrl+- Zoom Out
Ctrl+0 Fit to View
Ctrl+Shift+0 Reset Zoom (100%)

Help & Version

Both binaries support --help and --version:

merisio --help          # Print usage and exit
merisio --version       # Print version and exit
merisio-cli --help      # Print CLI usage and exit
merisio-cli --version   # Print CLI version and exit

Man Pages

Man pages are provided for both merisio(1) and merisio-cli(1).

# Install system-wide (requires root)
sudo python build.py install-man
man merisio
man merisio-cli

# Or read directly from source
man ./man/merisio.1
man ./man/merisio-cli.1

About MERISE

MERISE is a French methodology for database design, widely used in France and French-speaking countries. It uses:

Merisio helps you design at the conceptual level and automatically generates the logical and physical models.

License

GNU GPL v2

Author

Achraf SOLTANI

Acknowledgments

Inspired by the original AnalyseSI Java project.