# Add back Sequel Pro support **URL:** \ **Category:** Local Add-ons\ **Tags:** sequel-pro\ **Created:** [August 19, 2021, 1:26pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272 "2021-08-19T13:26:34Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![swissspidy](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/swissspidy/32/13956_2.png) [@swissspidy](https://community.localwp.com/u/swissspidy)\ **Post date:** [August 19, 2021, 1:26pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/1 "2021-08-19T13:26:34Z")
As per discussion at [Sequel Pro has been abandoned. New team has forked to Sequel Ace](https://localwp.com/community/t/sequel-pro-has-been-abandoned-new-team-has-forked-to-sequel-ace/21625), support for Sequel Pro was recently removed under the somewhat false premise of Sequel Pro being an abandoned project. However, on the referenced GitHub issue, the maintainer has clearly stated that the project is **not** dead: [https://github.com/sequelpro/sequelpro/issues/3705#issuecomment-653258075](https://github.com/sequelpro/sequelpro/issues/3705#issuecomment-653258075) Yes, the last stable version of Sequel Pro doesn’t run smoothly on never computers, but the nightly builds are more up-to-date and work great. See [https://sequelpro.com/test-builds](https://sequelpro.com/test-builds) Personally, I use Sequel Pro on a daily basis, and removal of support for it without at least providing Sequel Ace as an alternative is super frustrating for me as a user. ---
**Author:** ![ben.turner](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/ben.turner/32/5366_2.png) [@ben.turner](https://community.localwp.com/u/ben.turner)\ **Post date:** [August 19, 2021, 5:23pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/2 "2021-08-19T17:23:24Z")
Hey @swissspidy, Welcome to the Local Community Forums! Thanks for reaching out about Local and Sequel Pro, and I’m sorry that this has interrupted your workflow! I’ve moved this topic to the “Local Add-ons” category to help focus the conversation on possible ways that this functionality can be returned! Removing Sequel pro is part of a larger effort of the Local team to streamline and simplify the third-party tooling that we encourage users to use. This allows us to deliver a leaner, more stable core Local experience that can be extended by developers through the use of Add-ons. Sequel Pro is unique in that it was included a long time ago, before a Local add-on was even an option. As the latest stable version of Sequel Pro ([v1.1.2](https://github.com/sequelpro/sequelpro/releases/tag/release-1.1.2)) was released in April of 2016 and has become broken for many users, the Local team has had to field many support questions around users being confused about why Local encourages the use of broken software. As you mention, the nightly build of Sequel Pro does work, and the maintainer of Sequel Pro has said that they are working on the project. At the end of the day, if having a one-click connection to a Local site in Sequel Pro interests you, I encourage you to explore creating an add-on! - [https://localwp.com/get-involved/build/](https://localwp.com/get-involved/build/) In particular, the [TablePlus addon](https://localwp.com/add-ons/local-tableplus) seems to function in a similar manner to what you are trying to do with Sequel Pro, so you might consider reviewing that add-on’s repo: > **[GitHub - aubreypwd/localwp-tableplus: Local ⚡️ Addon for launching TablePlus...](https://github.com/aubreypwd/localwp-tableplus)** > > Local ⚡️ Addon for launching TablePlus (MacOS only) to view databases. - GitHub - aubreypwd/localwp-tableplus: Local ⚡️ Addon for launching TablePlus (MacOS only) to view databases. Hope that helps give some larger context into our decision to remove Sequel Pro from Local. If you have any questions, just let us know how we can help! ---
**Author:** ![Martin\_SD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/martin_sd/32/14020_2.png) [@Martin\_SD](https://community.localwp.com/u/Martin_SD)\ **Post date:** [August 23, 2021, 2:07pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/3 "2021-08-23T14:07:55Z")
If Sequel Pro is not the needed future-proofed solution, it would be great to get the get - «Sequel Ace» as quick-link replacement - or as a Addon like «Table Plus». **Alternative Woraround** Does anybody know a workaround or docs to connect a particular Local Database from Apps like Squel Pro/ Sequel Ace direct from the app direct. So I could create for each of the local-db’s a connection-favorites. (not very user-friendly, but better than the cluttered interface and reduced options of Adminer) Thank you ---
**Author:** ![ben.turner](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/ben.turner/32/5366_2.png) [@ben.turner](https://community.localwp.com/u/ben.turner)\ **Post date:** [August 23, 2021, 3:13pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/4 "2021-08-23T15:13:15Z")
As of right now, Sequel Ace can only connect to a MySQL database over TCP/IP (ie, a networking port) and not over a Unix socket. Windows machines already connect to the DB over TCP/IP because they don’t have unix sockets, but if you want to change a site under MacOS to use TCP/IP, then you can follow the steps outlined in this FAQ: - [How can I connect to MySQL using TCP/IP rather than a socket on macOS/Linux?](https://localwp.com/community/t/how-can-i-connect-to-mysql-using-tcp-ip-rather-than-a-socket-on-macos-linux/21220) Once the site has been updated, then you can connect to that database in whatever way your SQL client uses to connect over TCP/IP ---
**Author:** ![Martin\_SD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/martin_sd/32/14020_2.png) [@Martin\_SD](https://community.localwp.com/u/Martin_SD)\ **Post date:** [August 23, 2021, 4:03pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/5 "2021-08-23T16:03:23Z")
Hey Ben, Thank you for your help and the link. - **Should this also work with Sequel Pro out of the box?** (I have never had any problems accessing Local DB’s with Sequel Pro in the past.) Unfortunatelly Sequel Pro always throw an Mysql-Error: Unknown error 1045. Have done Clay’s advice «step 1 & step 2». ![Error-Throwing_blured](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/3/339f8e872ad3416a5d66f84c7e64f02093f811c3.jpeg) ![Used Settings](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/0/08f9e54149fe3036e147d8ed8f29ab1a01084cf4.png) - **Have I misunderstood something in Clay’s adviced steps?** - **Or does it not work with Sequel Pro as a connection-app?** - **Maybe only work with Sequel Ace?** ---
**Author:** ![ben.turner](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/ben.turner/32/5366_2.png) [@ben.turner](https://community.localwp.com/u/ben.turner)\ **Post date:** [August 23, 2021, 4:18pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/6 "2021-08-23T16:18:33Z")
I actually don’t know if this should work with Sequel Pro. As far as I know, the stable version of Sequel Pro is broken. Some users indicate that the nightly version of Sequel Pro does work, however I’ve never used it, so I personally can’t verify this. ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [August 24, 2021, 8:47pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/7 "2021-08-24T20:47:16Z")
You must use the Sequel Pro nightly. ---
**Author:** ![Martin\_SD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/martin_sd/32/14020_2.png) [@Martin\_SD](https://community.localwp.com/u/Martin_SD)\ **Post date:** [August 25, 2021, 9:24am UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/8 "2021-08-25T09:24:36Z")
Hey @anfragen, Thanks for your hint. Have downloaded Sequel Pro nightly. ![Bildschirmfoto 2021-08-25 um 11.12.07](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/a/a8c59c151389a08f61d83bc721819ddf2cf2eb47.png) Unfortunately the Error is the same with the SP-Nightly-Built: reconnect with SiteShell. User was still created (error 1396) and the Port seams to be the same as last time 10033. ![Error with Nightly](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/9/9bed677b14373ec2af160f91352cc7cd6a6b4761.jpeg) So I tried also the Sequel Ace App from AppStore: Also with TCP/IP Host: localhost Username: root Passwort: Database: local Port: 10033 Tried also check/uncheck Allow LOCAL-DATA-INFILE and Enable Cleartext plugin in all possibilities (uncheck, uncheck | uncheck, check | …) allways the same error: 1045 ![Sequel Ace Error 1045](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/1/1e085a04749cf913720967638414023eadbb7b4e.jpeg) What could throw this error? - **Do I have to set some stuff different?** - **Any Idea?** Maybe I missunderstood some basic stuff … ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [August 25, 2021, 1:52pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/9 "2021-08-25T13:52:12Z")
You must use the socket to connect, not the port. The socket will be shown in the Local site’s database tab. ---
**Author:** ![Martin\_SD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/martin_sd/32/14020_2.png) [@Martin\_SD](https://community.localwp.com/u/Martin_SD)\ **Post date:** [August 25, 2021, 2:24pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/10 "2021-08-25T14:24:51Z")
Hey @afragen, thanks for your hint with the socket again: I used in all 3 Apps the connection with socket: Copy/Paste from Databse-Tab. Unfortunately the 3 trials also only ends in errors: Tried with Sequel Pro, SP Nightly, and Sequel Ace… PS: Also tried with Database: local And checked/unchecked the 3 checkbox-options. ![ErrorWithSocket](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/9/901379a9849ec7d11959566c8c67a57f96e04257.jpeg) _(Tried Sequel Ace also to connect with public remote server. NO Problem there, so the app should have the permissions from Mac OS ;o()_ - **Any other idea, what I could make wrong so I only get an error on every App?** ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [August 25, 2021, 3:21pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/11 "2021-08-25T15:21:31Z")
You must all ALL the data. You are missing the password and database name ![screenshot_75](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/1/177c1f14afe0b55f8c4efd937a0e537297c7ac9a.jpeg) ---
**Author:** ![Martin\_SD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/martin_sd/32/14020_2.png) [@Martin\_SD](https://community.localwp.com/u/Martin_SD)\ **Post date:** [August 25, 2021, 6:30pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/12 "2021-08-25T18:30:54Z")
Hey @afragen You are great! _(I not so much)_ I have set the DB as local by the try&errors, also the three checkboxes. - But Password I thought should be empty. _(wrongheaded)_ Now, with root for password all is working! Insanely with the modernest App «Sequel Ace» I got still an connection-error with the totally-same credentials like in SP and SP Nightly: Can’t connect to local MySQL server through socket ‘/pathTo/Library/Application Support/Local/run/1KLWSRWOR/mysql/mysqld.sock’ **But anyway** , with: - Sequel Pro - Sequel Pro Nightly Built all works and I can use the well-rehearsed Workflow. Thank you for your patient ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [August 25, 2021, 8:29pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/13 "2021-08-25T20:29:27Z")
Sequel Ace is sandboxed for the Mac App Store and using sockets hasn’t quite been figured out yet. ---
**Author:** ![Martin\_SD](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/martin_sd/32/14020_2.png) [@Martin\_SD](https://community.localwp.com/u/Martin_SD)\ **Post date:** [August 25, 2021, 9:50pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/14 "2021-08-25T21:50:26Z")
Tried to find a solution with the «not sandboxed» Sequel Ace from Homebrew. But this throws same error. Seams to be a combination with your mentioned «hasn’t quite figured out yet» and the AppStore sandboxing. Anyway: Sequel Pro & Sequel Pro Nightly works like a charme. Hope for later, Sequel Ace will be fixed for the socket-problem and this will be a solution for replace the old «Sequel Pro» Shortlink in Local or maybe a solution with the Sequel Pro Nightly… Thanks for help ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [August 25, 2021, 10:09pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/15 "2021-08-25T22:09:30Z")
@brandondove @aubreypwd any chance for building an add-on similar to the TablesPlus add-on? ---
**Author:** ![brandondove](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/brandondove/32/10767_2.png) [@brandondove](https://community.localwp.com/u/brandondove)\ **Post date:** [August 25, 2021, 10:38pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/16 "2021-08-25T22:38:11Z")
Honestly, I tried. I actually created an issue about the sandboxing socket issue a little over a year ago ([https://github.com/Sequel-Ace/Sequel-Ace/issues/108](https://github.com/Sequel-Ace/Sequel-Ace/issues/108)). Unfortunately, it doesn’t look like there’s a good path forward at this point. @afragen, if you have any ideas, I’d be happy to look into it. ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [August 25, 2021, 11:24pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/17 "2021-08-25T23:24:19Z")
Actually Brandon I was simply thinking of bringing back support for Sequel Pro in this manner. The Sequel Pro nightly works fine with a socket. ---
**Author:** ![jchlu](https://avatars.discourse-cdn.com/v4/letter/j/ea666f/32.png) [@jchlu](https://community.localwp.com/u/jchlu)\ **Post date:** [November 18, 2021, 11:06pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/18 "2021-11-18T23:06:03Z")
Sequel Ace has instructions of how to use sockets with the sandboxed version (it requires specifying the socket location) e.g. in `my.cnf`: ```auto [mysqld] socket=/Users/YourUserName/Library/Containers/com.sequel-ace.sequel-ace/Data/mysql.sock ``` So it would be great to know how to over-ride the `{{socket}}` config to allow everything else to work properly. ---
**Author:** ![ben.turner](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/ben.turner/32/5366_2.png) [@ben.turner](https://community.localwp.com/u/ben.turner)\ **Post date:** [December 9, 2021, 7:05pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/19 "2021-12-09T19:05:54Z")
> [@jchlu](#): > > ```auto > [mysqld] > socket=/Users/YourUserName/Library/Containers/com.sequel-ace.sequel-ace/Data/mysql.sock > > ``` If I’m understanding correctly, then you likely just need to update the site’s `conf/mysql/my.cnf.hbs` file to that value, which looks like it’s the socket for Sequel Ace (?) The main issue I’d forsee with that is that you’d need to re-initialize and install WordPress because that DB would likely be blank. It also doesn’t seem to portable, but I’d be curious to hear if that ends up working for you! ---
**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/system/32/1_2.png) [@system](https://community.localwp.com/u/system)\ **Post date:** [March 9, 2022, 7:06pm UTC](https://community.localwp.com/t/add-back-sequel-pro-support/27272/20 "2022-03-09T19:06:26Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.