Open Automation Software
Liberate your Industry 4.0 data with Open Automation Software IIoT platform for Windows and Linux. OAS is truly an unlimited IoT Gateway for Windows, Linux, Raspberry Pi 4, Windows IoT Core, and Docker deployments.
Create HMI visualization for web, WPF, and WinForm C# and VB .NET applications.
Log data and alarms to SQL Server, Oracle, MS Access, MySQL, Azure SQL, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, and CSV files.
MQTT Broker and Client interface along with cloud connectivity to Azure IoT and AWS IoT Gateway.
Read and write data from remote Excel Workbooks.
Alarm notification to email, SMS text, and voice messaging.
.NET and REST API programmatic access.
Allen Bradley ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5.
Siemens S7-200, S7-300, S7-400, S7-1200, and S7-1500.
Modbus TCP, Modbus RTU, and Modbus ASCII for Master and Slave communications.
OPTO-22, MTConnect, and OPC UA, OPC DA.
Learn more
TablePlus
Modern, native client with intuitive GUI tools to create, access, query & edit multiple databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, Snowflake, Oracle, Redis.
Learn more
DBeaver Community
DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.)
SQL editor to create queries with syntax highlighting and autocompletion
AI assistant in SQL for building queries through natural language
SSL/TLS support for encrypted connections
SSH tunneling for secure remote access
Proxy configuration to work with databases behind a corporate firewall
Session Manager to terminate, disconnect, view and search for sessions
Lock Manager to monitor and manage database locks
Entity Relationship Diagrams to interactively explore and visualize database structure
Query manager to view all executed queries, including execution time, duration, affected rows, and errors.
Data editor to view, edit, and filter data
Learn more
HeidiSQL
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide. Free for everyone, OpenSource. Connect to multiple servers in one window. Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite. Connect to servers via commandline. Connect via SSH tunnel, or pass SSL settings. Create and edit tables, views, stored routines, triggers and scheduled events. Generate nice SQL-exports, compress these afterwards, or put them on the clipboard. Export from one server/database directly to another server/database. Manage user-privileges, import text-files, export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array. Browse and edit table-data using a comfortable grid.
Learn more