Open-source PHP projects categorized as SQL | Edit details

Top 16 PHP SQL Projects

  • countries-states-cities-database

    🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, YAML, and CSV. All Countries, States, Cities with ISO2, ISO3, Country Code, Phone Code, Capital, Native Language, Timezones, Latitude, Longitude, Region, Subregion, Flag Emoji, and Currency. #countries #states #cities

    Project mention: Laravel 9 has been released but should we really start using it? | | 2022-02-09

    Depending on what you need from this package, this might be of help

  • Leantime

    Leantime is a lean project management system for innovators. Designed to help you manage your projects from ideation to delivery.

    Project mention: Need software to maintain ideas, thinks working on etc. | | 2022-04-22

    Take a look at

  • SonarLint

    Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  • mysqldump-php

    PHP version of mysqldump cli that comes with MySQL

    Project mention: Periodic Database Backup to Gitlab Private Repository Using Flysystem and Cronjob | | 2022-02-11

    Mysqldump PHP by ifsnop

  • fluentpdo

    A PHP SQL query builder using PDO

    Project mention: Too much magic? — Matthias Noback | | 2022-03-18

    Try I'm not affiliated with it in any way, I just like to use it because it has no additional dependencies.

  • upscheme

    Database migrations and schema updates made easy

    Project mention: Symfony Station Communiqué — 11 February 2022. A look at Symfony and PHP news. | | 2022-02-11

    Speaking of Symfony-based e-commerce platforms, Aimeos announced “Since 2022.01 beta, the Aimeos core is using Upscheme for updating the database schema and migrating data between new releases. Upscheme is composer package for schema management based on Doctrine DBAL which offers an easy to use API. You can also integrate Upscheme it in your own application easily and this article explains the differences and how you can write migrations with only a few lines of code”

  • lessql

    LessQL: A lightweight and performant PHP ORM alternative

  • sql-parser

    A validating SQL lexer and parser with a focus on MySQL dialect. (by phpmyadmin)

    Project mention: Open Source SQL Parsers | | 2021-10-08

    SQL Parser in phpmyadmin is a validating SQL lexer and parser with a focus on MySQL dialect.

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • ATK Data

    ATK Data - Data Access Framework for high-latency databases (Cloud SQL/NoSQL). (by atk4)

  • Vulnerable-Web-Application

    OWASP Vulnerable Web Application Project

    Project mention: O que foi obtido pela invasão do TSE em 2018. | | 2021-08-05
  • KLiK-SocialMediaWebsite

    Complete PHP-based Login/Registration system, Profile system, Chat room, Forum system and Blog/Polls/Event Management System.

    Project mention: My journey making a social website | | 2021-07-26

    I cloned projects like Kirk social website on GitHub, tested it and looked trough the code to see how they did it.

  • client

    PHP client for Tarantool. (by tarantool-php)

    Project mention: Advanced MessagePack capabilities | | 2021-10-13

    That was an example of a simple UUID extension. Similarly, you can add support for any other type used in your application: DateTime, Decimal, Money. Or you can write a versatile extension that allows serializing any object (as it was done in KPHP). However, this is not the only use for extensions. I'll now show you some interesting examples that demonstrate other advantages of using extension types.

  • Gangster-Legends-V2

    A free to use text-based PBBG / MMORPG script

    Project mention: Making my own script | | 2021-09-02
  • Simple MySQLi Class

    :gem: Simple MySQLi Abstraction Layer + Doctrine/DBAL support

  • Luminosity

    Luminosity - A modern style blogging platform

    Project mention: A modern style blogging platform built using PHP without any frameworks | | 2022-04-22
  • Fregata

    Fregata - a PHP database migrator

    Project mention: What is your favourite totally pointless/experimental thing you have built? | | 2022-02-17

    A data migration framework:

  • sql-order-analyse-tools

    A tool used to check the order of columns in SQL table structure.

    Project mention: A tool used to check the order of columns in SQL table structure. | | 2021-12-09
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 2022-04-22.

PHP SQL related posts


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

Project Stars
1 countries-states-cities-database 3,088
2 Leantime 1,167
3 mysqldump-php 1,070
4 fluentpdo 863
5 upscheme 520
6 lessql 400
7 sql-parser 326
8 ATK Data 255
9 Vulnerable-Web-Application 211
10 KLiK-SocialMediaWebsite 203
11 client 60
12 Gangster-Legends-V2 48
13 Simple MySQLi Class 37
14 Luminosity 19
15 Fregata 14
16 sql-order-analyse-tools 0
Find remote jobs at our new job board There are 7 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives