Purpose is to provide similar-look console client for different SQL servers. It is for you, terminal-geek!
Inspired by mysql client and https://github.com/nitso/colour-mysql-console :)
- Database support (as of Doctrine):
- MySQL
- Oracle
- Microsoft SQL Server
- PostgreSQL
- SAP Sybase SQL Anywhere
- SQLite
- Drizzle
- PHP 5.3+
- php_pdo extension
- specific database driver
- console
To launch client just run phar file:
$ php console.phar
To connect a server you need to specify DSN (http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url):
SQL Console > connect mysql://root:password@localhost:3306/TEST
To execute a statement use e command:
SQL Console > e SELECT * FROM test_table
- autocompletion for SQL objects: databases/tables/fields
- autocompletion for SQL statements
- advanced SQL statement execution: prepared statements and bindable parameters
- table/vertical(like mysql \G)/json/php-array data output
Following libraries are used:
- https://github.com/symfony/console component for user interaction
- https://github.com/doctrine/dbal for database connectivity
\Nitso\SqlConsole\Shell class was inspired by Symfony\Component\Console\Shell and rewritten to modify private (sic!) methods of original class.
Requires https://github.com/humbug/box for building phar archive.
Just install project without dev dependencies composer install --no-dev and update application with box compile
