Download the PHP package sagrmore/indexpilot without Composer
On this page you can find all versions of the php package sagrmore/indexpilot. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download sagrmore/indexpilot
More information about sagrmore/indexpilot
Files in sagrmore/indexpilot
Package indexpilot
Short Description Framework-independent SQL index analysis and query optimization toolkit with first-class Laravel integration
License MIT
Homepage https://github.com/sagrmore/indexpilot
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package indexpilot
IndexPilot
Framework-independent SQL index analysis and query optimization toolkit with first-class Laravel integration.
IndexPilot analyzes SQL workloads, applies explainable recommendation rules, and renders reports (JSON, Markdown, HTML, SARIF, console) for local development and CI.
User documentation: start with the Enterprise User Guide — install, DB connection, Eloquent vs plain SQL, reports, CI, and production posture.
Requirements
| Component | Version |
|---|---|
| PHP | 8.1, 8.2, 8.3, 8.4 |
| Laravel (optional) | 10.x, 11.x, 12.x, 13.x |
Database engines
| Engine | Status |
|---|---|
| MySQL 8+ | Production (reference driver) |
| MariaDB 10.5+ | Production (first-class driver) |
| PostgreSQL 13+ | Production |
| SQLite 3.35+ | Production (embedded / local) |
| SQL Server 2019+ | Production (pdo_sqlsrv) |
See docs/certification/.
Installation
Laravel auto-discovers the service provider and IndexPilot facade.
Publish config (optional):
Standalone CLI (Composer bin):
Quick Start
PHP API
Artisan
Standalone CLI
Configuration
| Variable | Default | Description |
|---|---|---|
INDEXPILOT_ENABLED |
true |
Master package switch |
INDEXPILOT_CONNECTION |
null |
Database connection for analysis |
INDEXPILOT_COLLECTOR_ENABLED |
false |
Enable Laravel query listener |
INDEXPILOT_MIN_CONFIDENCE |
0.5 |
Minimum recommendation confidence |
INDEXPILOT_REDACT_BINDINGS |
true |
Redact sensitive binding values |
Full schema: config/indexpilot.php.
Operators: see the Enterprise User Guide for end-to-end usage.
Documentation
| Guide | Path |
|---|---|
| Enterprise User Guide | docs/user-guide.md |
| Laravel integration | docs/laravel-integration.md |
| CLI design | docs/engineering/cli-design.md |
| Reporting | docs/engineering/reporting-engine.md |
| Release readiness | docs/engineering/release-readiness-review.md |
| Database support matrix | docs/engineering/DATABASE_SUPPORT_MATRIX.md |
| MySQL certification | docs/certification/mysql.md |
| MariaDB certification | docs/certification/mariadb.md |
| PostgreSQL certification | docs/certification/postgresql.md |
| SQLite certification | docs/certification/sqlite.md |
| SQL Server certification | docs/certification/sqlserver.md |
| Troubleshooting | docs/troubleshooting.md |
| Upgrade notes | docs/UPGRADE.md |
| Architecture / ADRs | docs/adr/ |
Architecture
Hexagonal layout: framework-agnostic core + thin Laravel/CLI adapters. Architecture status: FROZEN (see docs/engineering/PROJECT_STATE.md).
Testing
CI matrix: PHP 8.1–8.4 × Laravel 10–13, plus mandatory database integration gates:
| Job | Service / notes |
|---|---|
| MySQL 8 Integration | mysql:8.0 |
| MariaDB 10.11 Integration | mariadb:10.11 |
| PostgreSQL 16 Integration | postgres:16 |
| SQLite Integration | pdo_sqlite (:memory: / DSN) |
| SQL Server 2022 Integration | mcr.microsoft.com/mssql/server:2022-CU25-ubuntu-22.04 + pdo_sqlsrv |
Live DB tests require:
| Engine | Variables |
|---|---|
| MySQL | INDEXPILOT_TEST_MYSQL_DSN, INDEXPILOT_TEST_MYSQL_USER, INDEXPILOT_TEST_MYSQL_PASSWORD |
| MariaDB | INDEXPILOT_TEST_MARIADB_DSN, INDEXPILOT_TEST_MARIADB_USER, INDEXPILOT_TEST_MARIADB_PASSWORD |
| PostgreSQL | INDEXPILOT_TEST_PGSQL_DSN, INDEXPILOT_TEST_PGSQL_USER, INDEXPILOT_TEST_PGSQL_PASSWORD |
| SQLite | INDEXPILOT_TEST_SQLITE_DSN (optional; default sqlite::memory:) |
| SQL Server | INDEXPILOT_TEST_SQLSRV_DSN, INDEXPILOT_TEST_SQLSRV_USER, INDEXPILOT_TEST_SQLSRV_PASSWORD, INDEXPILOT_TEST_SQLSRV_DATABASE |
Known limitations (v1.0.0)
IndexPilot::extend()is not implemented yet- Standalone CLI
--engineis a connection hint without opening a live PDO driver by itself - PHP CLI config files are executed via
requireand must be trusted (prefer JSON in CI)
Contributing
Please read CONTRIBUTING.md before submitting a pull request.
Security
If you discover a security vulnerability, please review our SECURITY.md policy.
License
The MIT License (MIT). See LICENSE for details.
All versions of indexpilot with dependencies
greenlion/php-sql-parser Version ^4.7
illuminate/support Version ^10.0|^11.0|^12.0|^13.0
psr/log Version ^3.0
symfony/console Version ^6.4 || ^7.0