I’m looking for recommendations on database management tools that run natively on macOS and can establish connections to Microsoft SQL Server instances. While command line tools would work, I’d prefer something with a graphical interface that offers syntax highlighting and table view for query results. I want to avoid running Windows in a virtual machine if possible. What are some good options for connecting to MSSQL from a Mac? Are there any free tools available or should I look into paid solutions? I mainly need to run queries and browse database schemas.
What’s your specific use case tho? Heavy data analysis or just occasional queries? If budget’s not an issue, you might want to check out Navicat. How complex are your schemas?
In my experience, Azure Data Studio is an excellent choice for managing SQL Server databases on macOS. It offers a user-friendly interface with features like syntax highlighting and effective table views for your queries. Being a free tool, it is an attractive option and receives regular updates from Microsoft. Alternatively, you might consider DBeaver Community Edition, which supports multiple databases, including SQL Server, and provides a good schema browsing experience. Both tools enable you to work efficiently without needing a virtual machine.
dbeaver’s been solid for me, tho it gets sluggish with big schemas. you should try tableplus too - it’s paid but the interface is super clean and connects to mssql no problem. free trial gives you plenty of time to test it out.