For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

LibreDB Studio is an open source SQL IDE that runs in your browser. Forty-one engines share one interface: PostgreSQL, MySQL, Oracle, Db2 LUW, SQL Server, SQLite, libSQL, DuckDB, MongoDB, Redis, Couchbase, Firestore, ClickHouse, Apache Druid, Elasticsearch, OpenSearch, Trino, BigQuery, Databend, Snowflake, Apache Spark, Apache Cassandra, Prometheus, Apache Kafka, etcd, Neo4j, Milvus, Qdrant, InfluxDB (InfluxQL), InfluxDB 3 (SQL), Oxia, S3-compatible object storage, Kubernetes, MQTT, RabbitMQ, OPC UA, MTConnect, Modbus, NETCONF, SNMP and Sparkplug B. Twenty-seven further engines, among them MariaDB, TiDB, Valkey and ScyllaDB, speak one of those wire protocols and connect through an existing driver unchanged, so forty-one drivers reach sixty-eight named engines in all. Some are read-only because their own SQL is, among them Druid, Elasticsearch and OpenSearch, and the non-SQL stores such as Kubernetes, S3-compatible storage, MQTT and SNMP are read-only by construction. Write queries with autocomplete, and turn on an optional AI agent that uses your own model key. The app starts fully configured and generates unique admin credentials on first boot, so no two installations share default passwords. All data and configuration stay on your own Droplet.

Software Included

Creating an App using the Control Panel

Click the Deploy to DigitalOcean button to create a Droplet based on this 1-Click App. If you aren’t logged in, this link will prompt you to log in with your DigitalOcean account.

Creating an App using the API

In addition to creating a Droplet from the LibreDB Studio 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB LibreDB Studio Droplet in the SFO2 region, you can use the following curl command. You need to either save your API access token to an environment variable or substitute it in the command below.

curl -X POST -H 'Content-Type: application/json' \
         -H 'Authorization: Bearer '$TOKEN'' -d \
        '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image":"sekoyatech-libredbstudio"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying LibreDB Studio

Connect to your Droplet with SSH:

ssh root@your_droplet_public_ipv4

The welcome message (MOTD) shows your app URL and tells you where the generated admin credentials are stored (/etc/libredb-studio.env). Read the admin password with:

cat /etc/libredb-studio.env

Then open http://your_droplet_public_ipv4:3000 in your browser and sign in with the admin email and password from that file.