dbgate VS harlequin

This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.

To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/

Link | Github | License

DbGate works in Windows, Linux, Mac, and your web browsers without compromises in functionality. Both SQL and noSQL databases are supported, from MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, to CockroachDB.

Have you tried dbgate? https://github.com/dbgate/dbgate

Try https://dbeaver.io/ or https://dbgate.org/ (which can work in web mode)

You should try https://dbgate.org/

For browsing the SQL data in an IDE, I prefer https://www.beekeeperstudio.io/ or https://dbgate.org/

The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ and https://dbgate.org/ . Both very nice for my somewhat simple querying needs

DbGate (https://dbgate.org/)

For the past four months I've been working (part-time, this is OSS after all) on Harlequin, a SQL IDE for DuckDB that runs in your terminal. I built this because I work in Data, and I found myself often reaching for the DuckDB CLI to quickly query CSV or Parquet data, but then hitting a wall when using the DuckDB CLI as my queries got more complex and my result sets got larger.

Harlequin is a drop-in replacement for the DuckDB CLI that runs in any terminal (even over SSH), but adds a browsable data catalog, full-powered text editor (with multiple buffer support), and a scrollable results viewer that can display thousands of records.

Harlequin is written in Python, using the Textual framework. It's licensed under MIT.

Today I released v1.0.0, and I'm excited to share Harlequin with HN for the first time. You can try it out with `pip install harlequin`, or visit https://harlequin.sh for docs and other info.