BLOG
Notes on local database work
How-tos and product notes from HiDataLinker — connections, SQL workflows, and keeping database tools on your machine.
Check a PostgreSQL Schema Against Wiki Don't Do This Rules from a Desktop GUI
HiDataLinker v1.3.0 Schema Health runs a PostgreSQL schema checkup against wiki Don't Do This–style rules, lists severity, and gives copyable fix SQL that you review and run yourself.
PostgreSQLfree database clientlocal-firstMITdesktop GUIDump and Migrate PostgreSQL Virtual Generated Columns from a Desktop GUI (PG 18+)
PostgreSQL 18 made virtual generated columns the default. HiDataLinker v1.3.0 keeps VIRTUAL and STORED clauses in Dump and same-engine migrate, and skips those columns in INSERTs.
PostgreSQLfree database clientlocal-firstMITdesktop GUITry PostgreSQL 19 SQL from a Desktop GUI (REPACK, ON CONFLICT DO SELECT, Visual EXPLAIN)
Try PostgreSQL 19 SQL from a desktop GUI: run REPACK and INSERT ... ON CONFLICT DO SELECT in HiDataLinker, use COPY TO FORMAT json on the server, and inspect plans with visual EXPLAIN ANALYZE / BUFFERS.
Connect STACKIT PostgreSQL Flex from a Desktop GUI (ACL + TLS 1.3)
Connect STACKIT PostgreSQL Flex from a laptop GUI: add your IPv4 to the instance ACL, copy the user Hostname, Port, and connection string, keep TLS on (officially always TLS 1.3), and paste into HiDataLinker, a free local-first PostgreSQL desktop client.
Connect Koyeb Serverless PostgreSQL from a Desktop GUI (sslmode=require)
Connect Koyeb serverless PostgreSQL from a laptop GUI: copy the Connection Details string, add sslmode=require (the psql URL often omits it), use port 5432 and koyeb-adm/koyebdb on a fresh service, and paste the URL into HiDataLinker, a free local-first PostgreSQL desktop client.
Connect Tiger Cloud Postgres from a Desktop GUI (sslmode=require / verify-full)
Connect Tiger Cloud Postgres from a laptop GUI: copy Console or credentials-file details, keep sslmode=require or tighten to verify-full once the signed cert is ready, and use the direct port—not the pooler—with HiDataLinker, a free local-first PostgreSQL desktop client.
Connect IONOS Cloud PostgreSQL from a Desktop GUI (NLB + ISRG Root X1 + verify-full)
Connect IONOS Cloud PostgreSQL from a laptop GUI: put a Network Load Balancer in front of the private LAN, use the cluster DNS name with sslmode=verify-full and Let's Encrypt ISRG Root X1, and skip the default postgres database on v2—with HiDataLinker, a free local-first PostgreSQL desktop client.
Connect Amazon RDS from a Desktop GUI (Security Group + global-bundle.pem + verify-full)
Connect Amazon RDS for PostgreSQL (or MySQL) from a laptop GUI: turn on public access, open the security group to your IP, and use global-bundle.pem with sslmode=verify-full—with HiDataLinker, a free local-first PostgreSQL and MySQL desktop client.
Connect ApsaraDB RDS from a Desktop GUI (Public Endpoint + Whitelist + verify-full)
Connect Alibaba Cloud ApsaraDB RDS for PostgreSQL (or MySQL) from a laptop GUI: apply for a public endpoint, replace the default 127.0.0.1 whitelist, enable SSL, and use ApsaraDB-CA-Chain.pem with sslmode=verify-full—with HiDataLinker, a free local-first PostgreSQL and MySQL desktop client.
Connect OVHcloud Databases from a Desktop GUI (IP + project CA + verify-full)
Connect OVHcloud Public Cloud PostgreSQL or MySQL from a laptop GUI: authorize your IP, avoid console sslmode=require alone for production, download the project CA for verify-full—with HiDataLinker, a free local-first PostgreSQL and MySQL desktop client.
Connect Neon Postgres from a Desktop GUI (Direct vs -pooler + sslmode)
Connect Neon Postgres from a laptop GUI: prefer the direct hostname over -pooler for sessions and dumps, keep sslmode and channel_binding, and fix SNI or scale-to-zero drops—with HiDataLinker, a free local-first PostgreSQL desktop client.
Connect Render Postgres from a Desktop GUI (External URL + sslmode)
Connect Render Postgres from a laptop GUI: use the External URL with sslmode=require, fix No SNI errors, and optionally tighten the IP allowlist—with HiDataLinker, a free local-first PostgreSQL desktop client.
Navicat Premium Lite Is Free — Until Your Org Hits 5 Users
Premium Lite is free for commercial use, but each organization gets only 5 complimentary accounts. HiDataLinker is a MIT local-first PostgreSQL + MySQL desktop client with no seat wall.
Free pgAdmin Alternative that Also Does MySQL (Desktop)
Want a free pgAdmin alternative desktop client that also handles MySQL? HiDataLinker is a MIT local-first MySQL + PostgreSQL GUI—no web server, no seat freemium walls.
Free TablePlus Alternative without the 2-Tab Free Cap
Hit TablePlus free’s 2 tabs / 2 windows limit? HiDataLinker is a free MIT local-first MySQL + PostgreSQL desktop GUI—no tab, window, seat, or connection freemium walls.
Free Sequel Ace / Sequel Pro Alternative That Also Does PostgreSQL
Outgrew Sequel Ace’s Mac-only MySQL focus? Try a free open-source MySQL + PostgreSQL desktop GUI—local-first, MIT, no seat or tab walls.
Free MySQL/PostgreSQL GUI without Beekeeper’s 2-plugin Community cap
Beekeeper Studio Community now caps community plugins at two. HiDataLinker is a free MIT local-first MySQL+PostgreSQL desktop client — browse, query, Dump, and migrate without a plugin-store ceiling.
HiDataLinkerBeekeeper StudioBeekeeper Communitypluginsfree Beekeeper alternativeMySQLPostgreSQLlocal-firstfree database clientConnect Docker MySQL/PostgreSQL from HiDataLinker — free desktop GUI
Open a Docker Compose or docker-run MySQL or PostgreSQL database in HiDataLinker — free local-first desktop GUI via localhost port maps, no Adminer detour.
HiDataLinkerDockerMySQLPostgreSQLdocker composedesktop GUIlocal-firstfree database clientFree MySQL/PostgreSQL dump & same-engine migrate in HiDataLinker
Clone a MySQL or PostgreSQL database between connections with HiDataLinker — free Dump to .sql and same-engine migrate, no Navicat Data Transfer seat wall.
HiDataLinkerMySQL dumpPostgreSQL dumpdatabase migrateNavicat alternativelocal-firstfree database clientdesktop GUIPaste DATABASE_URL into HiDataLinker — free MySQL/PostgreSQL desktop GUI
Connect Neon, Railway, Supabase, or .env DATABASE_URL strings in HiDataLinker — a free local-first MySQL and PostgreSQL desktop client with URL paste.
HiDataLinkerDATABASE_URLPostgreSQLMySQLdesktop GUINeonlocal-firstfree database client