Free SQL application for Mac

Joined
Aug 20, 2013
Messages
2
Reaction score
0
Points
1
I'm looking for a program to run SQL queries that is compatible for Mac OS X. Ideally I would like this to be free but I'm not sure that is possible.

I don't want or need to host a server (ie. I want it to work offline), I just want to import tables and query them myself. Most of the ones seem to need an online server.

Basically I'm looking for an equivalent to Oracle SQL Plus.
 

vansmith

Senior Member
Joined
Oct 19, 2008
Messages
19,924
Reaction score
559
Points
113
Location
Queensland
Your Mac's Specs
Mini (2014, 2018, 2020), MBA (2020), iPad Pro (2018), iPhone 13 Pro Max, Watch (S6)
You could use the database component of LibreOffice - it's free, it's offline capable and it let's you execute SQL commands.
 

Raz0rEdge

Well-known member
Staff member
Moderator
Joined
Jul 17, 2009
Messages
15,762
Reaction score
2,100
Points
113
Location
MA
Your Mac's Specs
2022 Mac Studio M1 Max, 2023 M2 MBA
The other alternative is to use SQLite a file based database. It's meant (and designed) for off-line use and all you need is the DB file you create to move you database around..

There are many GUI's you can use to manage your SQL commands if you don't want to use the command line (/usr/bin/sqlite3) interface like RazorSQL..
 

vansmith

Senior Member
Joined
Oct 19, 2008
Messages
19,924
Reaction score
559
Points
113
Location
Queensland
Your Mac's Specs
Mini (2014, 2018, 2020), MBA (2020), iPad Pro (2018), iPhone 13 Pro Max, Watch (S6)
Raz0r's solution is probably a much better one - it's lighter and pure SQL. Go with that one instead.
 
OP
K
Joined
Aug 20, 2013
Messages
2
Reaction score
0
Points
1
The other alternative is to use SQLite a file based database. It's meant (and designed) for off-line use and all you need is the DB file you create to move you database around..

There are many GUI's you can use to manage your SQL commands if you don't want to use the command line (/usr/bin/sqlite3) interface like RazorSQL..

Thanks for that! Very helpful :)

I thought RazorSQL costs money after a 30 day evaluation period.
 

Raz0rEdge

Well-known member
Staff member
Moderator
Joined
Jul 17, 2009
Messages
15,762
Reaction score
2,100
Points
113
Location
MA
Your Mac's Specs
2022 Mac Studio M1 Max, 2023 M2 MBA
Thanks for that! Very helpful :)

I thought RazorSQL costs money after a 30 day evaluation period.

Perhaps it does, I didn't look too closely. I'm sure there are other UIs if you wanted to go that route..
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top