Libraries tagged by mysql query

SQL optimizer and rewriter(assisted SQL tuning). - SQL 优化器和重写器(辅助 SQL 调优)。

Go to Download

A validating SQL lexer and parser with a focus on MySQL dialect.

Go to Download

A dead simple PHP class for building SQL statements. No manual string concatenation necessary.

Go to Download

A Laravel package to specify the tables that you do not want to drop while refreshing the database.

Go to Download

Doctrine SqlWalker extension to apply USE INDEX and FORCE INDEX hints using DQL on top of MySql. Works with both createQuery and createQueryBuilder.

Go to Download

MySQL migration query auto generate on Laravel/Lumen

Go to Download

Generate MySQL migration queries from actual DB and DDL

Go to Download

A simple facility to split SQL files into individual queries - supports MySQL and PostgreSQL

Go to Download

Custom SQL walker for Doctrine allowing usage of MySQL optimizer hints without need of native queries

Go to Download

With Laravel Query Adviser you can get more insights into the SQL queries created by Eloquent models used in your app. It logs the queries used by your application and provides a helpful overview of the SQL queries. You can rerun the SQL query to analyze the database impact or copy the SQL query to your clipboard. The handy card view allows you to quickly point out the pain points of your application's SQL queries.

Go to Download

Convert a boolean search query into a query that is compatible with a fulltext search.

Go to Download

A simple Laravel `Query\Builder` extension that adds MySQL-like "order by field" feature

Go to Download

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.

Go to Download

MySQL Report - Analyze and profile your TYPO3 database queries

Go to Download

High-performance, secure database layer for PHP and multi-driver capabilities

Go to Download