DataBoard

DataBoard is a powerful desktop application for creating interactive data dashboards. Connect to SQL Server, MySQL, PostgreSQL databases, or import CSV and Excel files to visualize your data with beautiful charts, tables, and KPIs. Features advanced query tools, dashboard parameters for dynamic filtering, and automatic file monitoring.

Download

Alternative Downloads: Windows (Portable ZIP) • Linux (.deb)

Key Features

🔌 Multi-Database & File Support

• SQL Server - Connect using standard authentication or Windows Integrated Authentication
• MySQL - Support for MySQL 5.7+ and MariaDB
• PostgreSQL - Full support for PostgreSQL 10+
• CSV Files - Import and visualize data from CSV files with configurable delimiters, encodings, and headers
• Excel Files - Support for .xlsx/.xls files with sheet selection and column type detection
• File Auto-Refresh - Automatically detects and reloads data when source files change
• Works seamlessly with remote databases via VPN or ZeroTier

📊 Rich Visualizations

• Interactive Charts - Line charts, bar charts, and pie charts with automatic series detection
• Data Tables - Scrollable tables with formatted values and sticky headers
• KPI Tiles - Large value displays for key metrics
• Status Indicators - Color-coded status tiles
• Gauges - Visual progress and percentage displays

🎨 Drag-and-Drop Dashboard Builder

• Intuitive grid layout with 12-column responsive design
• Resize and rearrange tiles with ease
• Auto-refresh intervals for real-time data (configurable per dashboard and per tile)
• Multiple dashboards with organization folders
• Favorites - Mark frequently used dashboards as favorites for quick access
• Dashboard Parameters - Add dynamic filters (text, number, date, dropdowns) that apply to all tiles
• Save and restore custom layouts
• Grid and list view modes for dashboard library

🔐 Secure Credential Management

• Passwords encrypted using OS-level keychain integration
• Secure storage with Electron's safeStorage API
• No plain-text credentials in configuration files
• Connection pooling for optimal performance

⚡ Advanced Query Features

• SQL Editor - Syntax highlighting, autocomplete, and search powered by CodeMirror
• Parameterized Queries - Use dashboard parameters in queries with template syntax
• Query History - Complete audit log of all query executions
• Configurable auto-refresh intervals per tile and per dashboard
• Live query execution with connection pooling
• Instant visualization updates
• Query testing with preview in tile editor

Advanced Features

📁 Organization & Personalization

• Folders - Organize dashboards into folders for better management
• Favorites - Star your most-used dashboards for quick access
• Themes - Light, dark, or automatic (follows system preference)
• View Modes - Switch between grid and list views for your dashboard library

🎯 Dynamic Dashboards with Parameters

Create truly interactive dashboards with filter parameters:

• Add text inputs, date pickers, and dropdown selectors
• Populate dropdowns dynamically from database queries
• Reference parameters in tile queries with {{parameter_name}} syntax
• Apply filters across all tiles in a dashboard simultaneously
• Set default values, validation rules, and group related parameters

📂 File Data Sources

Import and visualize data from local files:

• CSV Support: Customizable delimiters, encodings (UTF-8, Windows-1252, ISO-8859-1)
• Excel Support: Read .xlsx and .xls files, select specific sheets
• Auto-Type Detection: Automatically detects column data types or set manually
• Live Updates: Files are monitored for changes and data refreshes automatically
• Metadata Tracking: File size and modification timestamps

Screenshots

Connection Management

Easily manage multiple database connections with secure credential storage.

Tile Editor

Create tiles with a powerful query editor and instant visualization preview.

Settings

Customize your DataBoard experience with flexible configuration options.

Installation

macOS (Apple Silicon)

1. Download the latest .dmg file from Releases
2. Open the downloaded DMG file
3. Drag DataBoard to your Applications folder
4. Launch DataBoard from Applications

Important for macOS users:

• First launch: Right-click the app and select "Open" to bypass Gatekeeper
• You may need to grant Local Network permission in System Settings → Privacy & Security → Local Network
• You may need to also run the command sudo xattr -cr /Applications/DataBoard.app to allow this app to run.

Windows

Option 1: Installer (Recommended)

1. Download DataBoard Setup {version} x64.exe from Releases
2. Run the installer (no admin rights required)
3. Launch DataBoard from the Start Menu or desktop shortcut

Option 2: Portable (No Installation)

1. Download DataBoard-{version}-win.zip from Releases
2. Extract the ZIP file to any folder
3. Run DataBoard.exe directly

Note: User data is stored in %APPDATA%\DataBoard regardless of installation method.

System Requirements

Minimum Requirements

• macOS: macOS 11.0 (Big Sur) or later, Apple Silicon (M1/M2/M3)
• Windows: Windows 10 or later (64-bit)
• Memory: 4 GB RAM
• Storage: 500 MB available disk space

Network Requirements

• Access to SQL databases via:
  • Direct network connection
  • VPN (e.g., OpenVPN, WireGuard)
  • ZeroTier or similar mesh networking

Quick Start

1. Launch DataBoard and create your first connection
2. Add a database connection:
   • Click "Connections" in the sidebar
   • Click "New Connection"
   • Enter your database details (host, port, database name, credentials)
   • Test the connection
3. Create a dashboard:
   • Click "Dashboards" in the sidebar
   • Click "New Dashboard"
   • Give it a name and description
   • Optionally, add dashboard parameters for dynamic filtering
4. Add tiles:
   • Open your dashboard
   • Click "Add Tile"
   • Write your SQL query
   • Choose visualization type (auto-detected by default)
   • Save and watch your data come to life!

Supported Data Sources

Type	Authentication/Options	Notes
SQL Server	Standard, Windows Integrated Auth	Requires SQL Server 2012+
MySQL	Standard	Supports MySQL 5.7+ and MariaDB
PostgreSQL	Standard	Supports PostgreSQL 10+
CSV Files	File-based	Configurable delimiter (,, ;, \t, |), encoding, headers
Excel Files	File-based	.xlsx/.xls support, sheet selection, column type detection

CSV/Excel Features:

• Auto-detect column types or manually specify
• Custom date formats
• Skip rows (for files with metadata headers)
• Auto-refresh when files change
• File metadata tracking (size, modified date)

Configuration

Database Location

By default, DataBoard stores its data in:

• macOS: ~/Library/Application Support/DataBoard/data/databoard.db
• Windows: %APPDATA%\DataBoard\data\databoard.db

You can customize the database location in Settings → Database Path.

Appearance & Preferences

• Theme - Light, dark, or system theme (follows OS preference)
• Dashboard View - Grid or list view for dashboard library
• Auto-Collapse Sidebar - Automatically collapse sidebar when not in use
• Custom Database Path - Store application data in a custom location

Query History

All query executions are logged for audit purposes. View query history in the Query History section.

Dashboard Parameters

Create dynamic dashboards with user-controlled filters:

• Parameter Types: Text, Number, Date, Date Range, Single Select, Multi Select
• Static Options: Define dropdown options manually
• Dynamic Options: Populate dropdowns from database queries
• Template Syntax: Reference parameters in queries using {{parameter_name}}
• Validation: Set min/max values, regex patterns, required fields
• Grouping: Organize parameters into collapsible groups

Example:

SELECT * FROM sales
WHERE region = '{{region}}'
AND date >= '{{start_date}}'
AND date <= '{{end_date}}'

Privacy & Security

• Local-first: All data is stored locally on your machine
• Encrypted passwords: Database credentials are encrypted using OS keychain
• No telemetry: DataBoard does not collect or transmit usage data
• Open connections: You control which databases to connect to

Support

Getting Help

• Issues: Report bugs or request features in GitHub Issues
• Discussions: Ask questions in GitHub Discussions

Common Issues

macOS: "DataBoard cannot be opened"

• Right-click the app and select "Open" instead of double-clicking
• In System Settings → Privacy & Security, click "Open Anyway"

Windows: App won't start

• Make sure you're running Windows 10 or later (64-bit)
• Try running as administrator if using portable version

Connection errors

• Verify your database server is accessible from your machine
• Check firewall rules allow outbound connections
• Confirm credentials are correct with a test connection

Changelog

See CHANGELOG.md for version history and release notes.

License

DataBoard is released under the MIT License. See LICENSE file for details.

Credits

Created by Advenimus Software

---

Ready to visualize your data? Download the latest release and get started today!