PhpStorm Database Support

Your database, our treat

PhpStorm supports MySQL, PostgreSQL, MongoDB, Redis, SQLite, and many other DBMS dialects out of the box. Explore and manage your PHP databases without leaving the IDE.

  • PostgreSQL
  • MySQL
  • Oracle Database
  • Microsoft SQL Server
  • MongoDB
  • Redis
  • Azure SQL Database
  • Amazon Redshift
  • Amazon DynamoDB
  • SQLite
  • IBM Db2
  • H2
  • Sybase ASE
  • Exasol
  • Apache Derby
  • MariaDB
  • HyperSQL
  • Snowflake
  • Apache Cassandra
  • ClickHouse
  • Greenplum
  • Apache Hive
  • Vertica
  • CockroachDB
  • Couchbase
  • Google BigQuery
1 / 2(Current Item: 1)

Query away!

Edit schemas and table data, run queries, and analyze schemas with UML diagrams.

Joe
PHP Developer

I bought PhpStorm without knowing about the database tooling. Now that I’ve stumbled across this feature, I can retire the two other companion apps I was using for this very thing. Since the query consoles persist, I can have my boilerplate queries ready to go without having to retype them for the thousandth time.

Fabio Ivona
@FabioIvona

I just discovered that in @phpstorm you can assign a color to a database connection, allowing you to highlight when a production DB is active. No more <drop, ..., submit, ..., darn...> for me. That's why I can't live without @phpstorm! ❤️

1 / 5(Current Item: 1)

Uncompromised editor

Smart code completion, code inspections, live error highlighting, quick-fix suggestions, and refactoring capabilities are at your disposal – even when you write SQL within PHP code.

Reach the full potential of your database

PhpStorm includes the full functionality of DataGrip, a powerful cross-platform tool for relational and NoSQL databases.

Learn more about DataGrip’s features.

The PHP IDE for Professional Web Developers

Join over 600,000 happy PhpStorm users worldwide!

Download PhpStorm