10 ms·
HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
- BrentOzar 8y agoIt's a Windows app. Github repo is here: https://github.com/HeidiSQL/HeidiSQL/ https://github.com/HeidiSQL/HeidiSQL/ The repo doesn't show releases, but the heidisql.com site has nightly builds done directly from the master branch.
- paulryanrogers 8y agoFWIW, it does work on Wine
- andrewmackrodt 8y agoWorks very well with Wine (but only with non Hi-DPI displays when and the Windows Version is set to 2003). It's my favourite client on desktop Linux / Windows.
- voltagex_ 8y agoIs there any way to improve the HiDPI support? I remember that Wine was doing some work on that in recent versions.
- kristianp 8y agoLooks like it's written in Pascal!
- cowmix 8y agoSo what's the best x-platform SQL client these days?
- paulryanrogers 8y agoDBeaver is popular if sluggish at times
- mbertschler 8y agoI recently discovered DBeaver and can highly recommend it. It is a bit more complicated to use than some alternatives, but really powerful. Also supports a large number of databases. https://dbeaver.io/ https://dbeaver.io/
- dt_rsp 8y agoI like DBeaver. YMMV.
- badhombres 8y agoI would argue Datagrip has yet to fail me while having a ton of support for many databases. Including support for MySQL 4.0.16. I had to use that DB for my previous job about a year ago. With datagrip I just needed to download an old jar file and I had a connection automatically.
- adl 8y agoDataGrip (not OpenSource) is pretty good.
- strictnein 8y agoFor Mac and Windows I really like TablePlus: https://tableplus.io/ https://tableplus.io/ First saw it here.
- lchsk 8y agoA simple postgres client I'm working on in my free time: https://sanchosql.com/ https://sanchosql.com/ Linux only now but it's open source so it should be possible to compile for win/mac
- manigandham 8y agoDBeaver is solid and supports the most DBs with lots of handy features: https://dbeaver.io/ https://dbeaver.io/ Jetbrains Datagrip is popular too, more intelligent but less DBs than DBeaver: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/ If you want a web-based tool, especially for Postgres, then OmniDB is a good choice: https://www.omnidb.org/en/ https://www.omnidb.org/en/
- soperj 8y agoI'll second DBeaver.
- pca2 8y agothird!
- morenoh149 8y agofourth dbeaver db support and data model diagramming
- brylie 8y agoInterestingly, OmniDB is built with Django. DBeaver has support for many databases through JDBC.
- da_chicken 8y agoI'm a big fan of Aqua Data Studio. I'd never heard of it until my current position, but it's very nice.
- taylorwc 8y agoI enjoy Sqlectron. Good cross-platform support, and a terminal option if you'd prefer.
- mamcx 8y agoI use Valentina: https://www.valentina-db.com/en/ https://www.valentina-db.com/en/ it work well. Even work with Sql Server on osx!
- mmsimanga 8y agoI use three tools interchangeably. DBeaver as mentioned by other comments. Squirrel SQL[0] has been around for a very long time. I have been using it for well over 10 years. Probably 15. Don't be fooled by the dated screenshots. First thing I always do it change the look and feel to Windows native then looks like any other Windows application. SQL Workbench/J[1]. Has tonnes of features, is well documented. I particularly like the headless mode which allows me to automate running of SQL statements using a batch file. [0]http://squirrel-sql.sourceforge.net/ http://squirrel-sql.sourceforge.net/ [1]https://www.sql-workbench.eu/ https://www.sql-workbench.eu/
- Bishonen88 8y agoCan only say 10000 good things about DataGrip
- Risse 8y agoI have been using HeidiSQL with Wine for couple of years now, works great! It does have some bugs though, like after running a large SQL file the UI just freezes and you have to kill the program.
- windsurfer 8y agoI really love using HeidiSQL as well, but I have the same issue. If I'm running large SQL files, I'm either using workbench or the CLI app.
- Max_aaa 8y agoIf I need a GUI for MySQL, I find MySQL Workbench to work great: https://www.mysql.com/products/workbench/ https://www.mysql.com/products/workbench/ But in 90% of cases, I do find that the cli sql client for your DB of choice is sufficient.
- martin-adams 8y agoI used the workbench all the time. Only niggle is that it hangs if you connect to an older version of MySQL, but the older version of Workbench works.
- jamisonbryant 8y agoI wish I had the same experience as you. I use MW at my work and it is constantly crashing, hanging, freezing, and otherwise puttering out. We don't have a stupidly large database either. Lately I've been hounding my team to switch to another product, such as HeidiSQL or DBeaver.
- dariusj18 8y agoDoes this app actually export to CSV correctly, because MySQL Workbench and SSMS both screw it up?
- jasonjayr 8y agoThough I'm not familiar with the CSV export of those two tools, I've had adventures in CSV parsing from other tools. How do they screw it up? Is there a canonical "correct" way defined somewhere?
- sbuttgereit 8y agoI wonder what percentage of CSV represented data 1) passes through a spreadsheet at some point from data source to final data consumption and 2) how much of that spreadsheet action is specifically MS Excel. You're right, there is no standard that I'm aware of, though the answer to those first two questions could well be a proxy for a de facto standard in practice.
- dariusj18 8y agoI cannot remember exactly how they each screw it up, but the issues I have had are, but not limited to, a) truncation of data b) removal of line breaks c) not escaping enclosing values, ex. " as "" d) using \n or other values in place of actual line breaks or tabs e) using \N for NULL values (which isn't too bad, but it would be nice to be able to configure this) f) in general not complying with https://tools.ietf.org/html/rfc4180 https://tools.ietf.org/html/rfc4180
- sabas_ge 8y agoNo 'standard' but you could check and use the FrictionlessData specifications from OKFN (https://frictionlessdata.io/specs/csv-dialect/ https://frictionlessdata.io/specs/csv-dialect/)
- ssddanbrown 8y agoI'm not sure about HeidiSQL but I've had great luck with MySQL database exports using PHPStorm. I think PHPStorm essentially has DataGrip built-in: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/ After having trouble with workbench, Using PHPStorm I was able to export a whole database to a file per table in one go and both TSV/CSV are supported. I found my resultant CSV files to be reliably escaped.
- stevoski 8y agoI have a slightly off-topic question: what tool do you recommend for creating Entity Relationship Diagrams (also known as database models)?
- Dnguyen 8y agoI use pgModeler for Postgres. Although lately I've been using Valentina Studio and it has a decent schema modeler too.
- openbasic 8y agoI've been looking for something decent in Linux too.
- thedangler 8y agoI use Enterprise Architect at work. If you have money its worth it.
- pjmlp 8y agoI had a couple of projects where it was the official modelling tool. Can vouch for it, one of the best experiences with enterprise modelling tools.
- iblaine 8y agoI prefer lucidchart for being easy to integrate to confluence and share with teams.
- bouncing 8y agoDia. https://wiki.gnome.org/Apps/Dia/ https://wiki.gnome.org/Apps/Dia/
- ediardo 8y agof you're using MySQL/MariaDB: MySQL Workbench https://www.mysql.com/products/workbench/ https://www.mysql.com/products/workbench/
- brylie 8y ago
- justkez 8y agoFeel like I've trialled every multi-DB client under the sun. Spent a good deal of time with Valentina, then DataGrip but firmly in bed with TablePlus (http://tableplus.com http://tableplus.com) now. First class Mac native experience and it's hard to see ever giving it up! There's a Windows build I've not used.
- eerikkivistik 8y agoCan back this up, TablePlus is really well implemented and a pleasure to use!
- raphaelj 8y agoI really like TablePlus too and bought the premium version a couple of weeks ago. The native UI is very nice. It's a very nice and cheaper alternative to Navicat. I still experience bugs from time to time. But it's improving.
- filmgirlcw 8y agoWant to also plug TablePlus — I got it in my SetApp subscription but it’s one I would have no problem buying outright. Really good stuff and consistently developed.
- chime 8y agoHuge fan of SetApp here. I subscribed months ago and absolutely love being able to just search, install, and get on with my work. Sure it is much cheaper to directly buy software you will use forever but that’s not why I use SetApp. I use it because it makes the hunt for apps obsolete. Any time I think I need software to do something, I have been able to find it instantly on SetApp. From PDF search to simple image editor to TablePlus, it makes me so much more relaxed about finding and installing the right app.
- h1d 8y agoThere's something about UI polish that puts me off from converting from SequelPro like space padding and font sizes.
- d4nc00per 8y agoThe Postgres support was no good last time I tried. I'm using dbeaver now on linux
- bouncing 8y agoYou might consider DataGrip -- it's got surprisingly good Postgres support and even does ssh tunneling quite nicely.
- nwsm 8y agoHeidi, DbVisualizer, and DataGrip are all great.
- glogla 8y agoIs there a gui client that can do both "normal" databases (like postgres and oracle) and Hive or Presto?
- ken 8y agoInduction [1] was supposed to be that, but the webpage is long gone, and it looks like there's just a source dump on GitHub with "alpha" code that hasn't been touched in 5 years. [1]: https://github.com/pothibo/Induction https://github.com/pothibo/Induction
- gglanzani 8y agoIf you add the hive jdbc fat jar, Datagrip can talk to Hive server 2
- T3RMINATED 8y agoUse Navicat its better.
- timvisee 8y agoIt's one of the best free apps I've used when I was still developing on Windows, and it's one of the few tools I miss for development when on other platforms. If you haven't yet, give it a try!
- markn951 8y agoFor working with MySQL on Mac, I really enjoy Sequel Pro [1]. Full native (and kinda old-skool, if you dig that kinda thing) Mac experience/design. Works fast. Is free. [1] https://sequelpro.com https://sequelpro.com
- pi-rat 8y agoI use Sequel Pro almost daily, pretty damn good, and you can't complain about the price :)
- Ancient 8y agoI used the regular Sequel Pro for years but just recently switched to the nightly version, which usually it's stable and has more updates. I recommend the switch to nightly. They share the same DB configurations you have created, so no need to worry that you have to import/export.
- pi-rat 8y agoThanks, I didn't know about their nightly builds, and it seems that nightly (true to it's name) supports dark mode. Awesome :)
- h1d 8y agoIt's buggier as it crashes on me every few days but can't connect to MySQL 8 otherwise but the way development is going on, the product seems like a dead end which is too bad.
- cholmon 8y agoOne of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006 https://www.heidisql.com/forum.php?t=1006 It'll search through all text fields of all tables of whichever database you specify for a given string, and displays a nice per-table summary for each matching record. I haven't found anything like this in any other DB client.
- mmsimanga 8y agoSQL Workbench/J has this feature[0]. I often use this feature when someone asks me questions about a report and I don't have a clue which tables that data comes from. Just search the database. [0]https://www.sql-workbench.eu/manual/dbexplorer.html#table-search-client https://www.sql-workbench.eu/manual/dbexplorer.html#table-se...
- DKnoll 8y agoThere's an extension for SQL Server Management Studio that does it (MSSQL) as well. I don't think it's really recommended for prod DBs though.
- anjanb 8y agoI don't have to do this frequently but if any dev/QA/myself need to do this, I dump the DB and run grep. Not the fastest way for sure but gets the job done!
- clintboxe 8y agoSo many people sleeping on DB Visualizer. It’s been around forever, can connect to anything with a JDBC driver, has a ton of features, and is updated frequently. My favorite is the ability to quickly full text search any query I’ve ever run. https://www.dbvis.com/ https://www.dbvis.com/
- elmigranto 8y agoSounds interesting, but what are good examples of "Visualizer" part? Screenshots section [1] only has 6 (pretty primitive [2]) images out of about a 100 total, but maybe that is outdated? [1] https://www.dbvis.com/features/software-screenshots/ https://www.dbvis.com/features/software-screenshots/ [2] https://www.dbvis.com/images/features/screens/chart3.png https://www.dbvis.com/images/features/screens/chart3.png
- ztjio 8y agoThis has been around a long time. I used to use it when working with DBs in awkward places, like RDP accessed Windows servers. Since it doesn't require an install, it was handy to just put it on a shared local folder and run it from there on the remote server. Never had any real complaints but it wasn't anything I'd used for regular work. I tend to prefer using the DB plugins in IntelliJ IDEA Ultimate or, if they aren't great, then something specific to the DB at the time.
- parrellel 8y agoOh! This is still a thing? Cool! I lost track of it when I switched over to Linux.
- jaequery 8y agoIt doesn't support Mac OSX?
- cseelus 8y agoIf you are on macOS and use Postgres, give https://eggerapps.at/postico/ https://eggerapps.at/postico/ a try. Haven't used a better DB GUI Client and it looks great with Mojaves new dark mode :-)
- hpvic03 8y agoIf you're on Mac, Try PopSQL: https://popsql.io/ https://popsql.io/ . It's excellent.
- DiabloD3 8y agoSo how does this actually compare to Datagrip?
- giancarlostoro 8y agoI usually use this on Windows but now that I have all JetBrains tools I opt for DataGrip the most since its cross platform. But also this gets tricky when you want to open a MSSQL db thats local for development I forgot what Microsoft calls it but it may as well be called MSSQLite.
- exabrial 8y agoI still think the best sql client in existence is sequelpro. It only works with mysql but the ui and feature set is incredible.
- h1d 8y agoUI polish and snappiness can't be beaten, which in turn locks me into using MySQL..
- MarsAscendant 8y agoDownloads are programmatically disallowed while you're viewing the page under an ad blocker. Of course, it only disallows the downloads via clicking the link. Easily circumventable.
- lillesvin 8y agoYou can install it with chocolatey without ever visiting the site.
- MarsAscendant 8y agoYou're seriously overestimating my ability to operate command line. I'm only here for a serious discussion.
- xellisx 8y agoI'll have to check out some of these I havent heard of. I use SQLYog (there is an opensource community edition)
- max23_ 8y agoI have been using this ever since SSMS (when it was built with WinForm IIRC) was a pain to use in my old job and my OS was Windows XP. Plus, I can update single column field from the query result by double clicking it.
- dizzystar 8y agoA while back, I was fixing up procedures in PL/pgSQL for a company. The procedures had to be rewritten, and they all sort of looked like this: create function... """ declare some string "'"this string"'" int """ end; The cross-database client didn't support or comprehend $$ escaping, so the people who wrote everything had no choice but the write with loads of quotes everywhere. I didn't realize this, so I passed some code back to them and they couldn't run it at all. The client-specific programs are all optimized to the RDMS you are using, so I never was able get on board with these products.
- creUsNa 8y agoProps to Ansgar Becker for maintaining this awesome SQL client pretty much by himself. HeidiSQL is hands down the best SQL client I've used.