Simple MySQL proxy for query logging with web GUI
Alternatives To Lottip
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Shadowsocks Qt57,866
4 years ago75lgpl-3.0C++
A cross-platform shadowsocks GUI client
6 months ago116gpl-3.0Objective-C
GUI for v2ray-core on macOS
a day ago185bsd-2-clausePHP
OPNsense GUI, API and systems backend
Zan Proxy1,37824 years ago1January 17, 201918mitTypeScript
An extensible proxy for PC/Mobile/APP developer
a year ago38mit
A GUI proxy client for Windows / Mac / Ubuntu Desktop based on Clash and Electron. Windows / Mac / Ubuntu 适用的Clash客户端.
Koolshare Clash873
3 years ago41gpl-3.0ASP
:cat: Run Clash Tunnel on Koolshare OpenWrt
Youtube Dl Wpf662
12 days ago5gpl-3.0C#
A simple GUI wrapper for youtube-dl and yt-dlp.
21 days ago49gpl-2.0Perl
Engintron for cPanel/WHM is the easiest way to integrate Nginx on your cPanel/WHM server. Engintron will improve the performance & web serving capacity of your server, while reducing CPU/RAM load at the same time, by installing & configuring the popular Nginx webserver to act as a reverse caching proxy in front of Apache.
17 days ago9apache-2.0Go
Windows 平台的 FRP GUI 客户端 / A user-friendly desktop GUI client for FRP on Windows.
9 days agogpl-3.0Python
A PySide6-based cross platform GUI client that launches your beloved GFW to outer space. Support Xray-core and hysteria.
Alternatives To Lottip
Select To Compare

Alternative Project Comparisons


Lottip is proxy for MySQL RDBMS with web GUI. It will show you what's happening under the hood of your database layer. As it sits between your application and MySQL server there's no need to use tools like Wireshark or enable general logs to see which queries are being executed. It comes as single binary with zero dependencies and consists of 2 parts: proxy server and embedded GUI.


Query list Freezed query Query error In app results
Example 1 Example 2 Example 3 Example 4

Main features

Lottip is on it's early stage of development.

For now you can:

  1. See all queries sent from your application to MySQL grouped by connection it belongs to.
  2. Track query execution result: success(green indicator), pending(yellow indicator) and error(red indicator).
  3. See query execution time(it includes time to transfer data over network).
  4. Filter queries by string.
  5. Execute any query and see results immediately.
  6. Run lottip in Docker container. Thanks to @tm-lmathieu



Get binaries from releases page

From sources on Mac/Linux
go get github.com/orderbynull/lottip
go install github.com/mjibson/esc
cd $GOPATH/src/github.com/orderbynull/lottip
$GOPATH/bin/esc -o fs.go -prefix web -include=".*\.css|.*\.js|.*\.html|.*\.png" web
go build

How to run

There're 4 simple steps to get everything up and running:

  1. Run binary from terminal like this: ./lottip_linux_amd64. You'll see something like this:

    Forwarding queries from '' to ''

    Web gui available at ''

  2. Tell your app to connect to MySQL via port 4041 instead of 3306.

  3. Go to and you'll see nice GUI.

  4. Play with your app and see all SQL-queries flowing between your app and MySQL. No need for page refresh because websockets are used to communicate between frontend and backend.

Use cases

Here're few use cases i use on my everyday basis so it may be helpful to someone.

Use locally

Just run lottip on your local machine and point your app to it. You can also run few lottip instances each on it's own port. This is an easy way to keep multiple app separated and view queries independently.

Use remotely

Let's say you're writing your PHP code locally but run it on dev server and do not want to expose lottip to outside world. In this case here's what you may do:

  1. Upload lottip binary to remote dev server and run it like this: ./lottip_linux_amd64
  2. Create ssh tunnel from your local machine to remote dev server like this: ssh -nNT -L 9999: [email protected]. This command will map your local :9999 to remote :9999
  3. Tell your remote app to use MySQL on port :4041
  4. Open locally.


You can change default values to whatever you need.

option available default value description
--proxy <ip>:<port> of proxy server. Your code should make connections to that address to make proxy work. Example: --proxy=
--mysql <ip>:<port> of MySQL server. Example: --mysql=
--gui <ip>:<port> of embedded GUI. Example: --gui=
--mysql-dsn "" If you need to execute queries from the app you need to provide DSN for MySQL server. DSN format: [username[:password]@][protocol[(address)]]/[dbname[?param1=value1&...&paramN=valueN]] All values are optional. So the minimal DSN is /dbname. If you do not want to preselect a database, leave dbname empty: / Example: --mysql-dsn=root:root@/


  • [ ] Write Unit tests
  • [ ] Implement more features of MySQL protocol
  • [x] Add query filtering by string
  • [ ] Add sql code highlighting
  • [ ] Add sql code formatting
  • [x] Add possibility to execute query right from GUI and see results
  • [ ] Add ssl support
  • [ ] Add support of PostgreSQL protocol
  • [ ] ... and more

Known problems

Currently lottip does not support secure connections via ssl. The workaround is to disable SSL on MySQL server or connect with option like --ssl-mode=DISABLED


You're very welcome to report bugs, make pull requests, share your thoughts and ideas!



Popular Gui Projects
Popular Proxy Projects
Popular User Interface Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.