Open-source PHP projects categorized as MySQL

Top 23 PHP MySQL Projects

  • Matomo

    Liberating Web Analytics. Star us on Github? +1. Matomo is the leading open alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. We love Pull Requests!

    Project mention: Mobile apps illegally share your personal data | | 2023-09-14

    You can for example use analytics that aren't spyware, and hence don't even have to try to trick users giving "consent" to things they don't really want.

    Seriously: what share of people actually want their behavior to be tracked for ad companies to make more money?

  • dbal

    Doctrine Database Abstraction Layer

    Project mention: PHP + Informix + Framework? | /r/PHP | 2023-05-22

    In that case, write your own platform and db driver that translates it, doctrine already has tons of work done which can be easily extended : - or simply use PDO directly as it can do raw queries and forget ORMs in general for such usecase.

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • coolify

    An open-source & self-hostable Heroku / Netlify alternative. Cloud version available here ->

    Project mention: Render nuked my entire account with no notice | | 2023-08-13

    Sorry to hear that. For a rock solid alternative, I use Hetzner with Coolify ( installed, it's an open source Heroku alternative that uses Docker. I deploy all my apps on a 10 dollar Hetzner VPS that can handle millions of hits, it's great.

  • phpMyAdmin

    A web interface for MySQL and MariaDB

    Project mention: 👻Top 8 Free, Open Source SQL Clients🔥 | | 2023-09-04

    phpMyAdmin was born in 1998, written in PHP, and is a classic SQL client. It was the default tool for LAMP and MAMP at that time. phpMyAdmin has grown to become one of the leading tools for managing MySQL and MySQL-like databases (e.g. MariaDB) It has over 200,000 direct downloads per month (and countless other users install it using prepackaged installations or using package managers).

  • Adminer

    Database management in a single PHP file

    Project mention: mySQL Backup Script without mysqldump | /r/PHPhelp | 2023-07-16

    Or, more PHP now, do you have phpmyadmin or can run adminer - single file?

  • countries-states-cities-database

    🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities

    Project mention: Where do websites get country-state-city data? | /r/learnprogramming | 2023-06-20

    At $WORK I created a prototype that used for a city/state/country typeahead widget - it was generally ok, loaded data into a read-only sqlite db that was created at container build time. We shipped it to AWS for the demo. There are some data bugs, cities in Turkey and Geneva were the top reported issues. You get what you pay for I suppose. Have not seen Geonames before this post but agree the username vs some form of api key/auth is weird.

  • Medoo

    The lightweight PHP database framework to accelerate the development.

    Project mention: Recommend a pre-written framework for basic, local, offline xampp-based software? | /r/PHPhelp | 2023-02-19

    Before moving to using full frameworks my go to for this kind of thing was Medoo: super simple and removed a lot of the headache.

  • Mergify

    Tired of breaking your main and manually rebasing outdated pull requests?. Managing outdated pull requests is time-consuming. Mergify's Merge Queue automates your pull request management & merging. It's fully integrated to GitHub & coordinated with any CI. Start focusing on code. Try Mergify for free.


    Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.

    Project mention: Self hosted open source CRM for business purposes | /r/selfhosted | 2023-07-12
  • devilbox

    A modern Docker LAMP stack and MEAN stack for local development

    Project mention: Multi site local development environment using Docker | /r/webdev | 2023-06-26


  • Bolt

    Bolt is a simple CMS written in PHP. It is based on Silex and Symfony components, uses Twig and either SQLite, MySQL or PostgreSQL. (by bolt)


    Single file PHP script that adds a REST API to a SQL database

    Project mention: Need something to host a URL that listens for a POST and then talks back to on-prem SQL. | /r/sysadmin | 2023-05-10

    For quick dev/arch projects at home, I usually use this:

  • Easy!Appointments

    :date: Easy!Appointments - Self Hosted Appointment Scheduler

    Project mention: Is there an open source booking system for vets? | /r/webdev | 2023-05-30

    I found this one, but I don't know what it's worth it? ( feel free to remove if it breaks the community guidelines )

  • takeout

    Docker-based development-only dependency manager. macOS, Linux, and WSL2-only and installs via PHP's Composer... for now.

  • mysqldump-php

    PHP version of mysqldump cli that comes with MySQL

  • upscheme

    Database migrations and schema updates made easy

  • MyBB

    MyBB is a free and open source forum software.

    Project mention: PhpBB | | 2023-06-16

    I actually recommend myBB [0] over phpBB for anyone looking to set up a LAMP forum. It's cleaner, better written, and possibly better maintained and with a much less scary vulnerability history. I believe it started off as an attempt to create an OSS version of IPB (or was it vB?).

    [0]: or

  • fluentpdo

    A PHP SQL query builder using PDO

  • postfixadmin

    PostfixAdmin - web based virtual user administration interface for Postfix mail servers

    Project mention: Postfix on the next level (Addons) | /r/mailserver | 2023-03-29

    1) PostfixAdmin

  • pomf

    Pomf is a simple lightweight file host with support for drop, paste, click and API uploading.

    Project mention: Zippyshare is shutting down | /r/Piracy | 2023-03-19

    Not much of a point to that. File upload forms are pretty trivial for one, and there already are plenty of good open-source solutions for that (e.g. send or pomf). Your main challenge is going to be finding the disk space/bandwidth for that sort of thing, but anyone with enough resources can already run a zippyshare "clone" with zero issues.

  • Thelia

    Thelia is an open source tool for creating e-business websites and managing online content. Repo containing the new major version (v2)

  • eLabFTW

    :notebook: eLabFTW is the most popular open source electronic lab notebook for research labs.

    Project mention: ELN options | /r/labrats | 2023-06-30

    +1 for

  • laravel-mysql-spatial

    MySQL Spatial Data Extension integration with Laravel.

  • InfluxDB

    Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-09-14.

PHP MySQL related posts


What are some of the best open-source MySQL projects in PHP? This list will help you:

Project Stars
1 Matomo 18,170
2 dbal 9,169
3 coolify 8,915
4 phpMyAdmin 6,745
5 Adminer 5,814
6 countries-states-cities-database 5,420
7 Medoo 4,718
9 devilbox 4,218
10 Bolt 4,160
11 PHP-CRUD-API 3,407
12 Easy!Appointments 2,791
13 takeout 1,531
14 mysqldump-php 1,187
15 upscheme 1,080
16 MyBB 967
17 laravel-cross-eloquent-search 962
18 fluentpdo 909
19 postfixadmin 882
20 pomf 850
21 Thelia 822
22 eLabFTW 801
23 laravel-mysql-spatial 773
Collect and Analyze Billions of Data Points in Real Time
Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.