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.
Edit schemas and table data, run queries, and analyze schemas with UML diagrams.
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.
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! ❤️
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.
PhpStorm includes the full functionality of DataGrip, a powerful cross-platform tool for relational and NoSQL databases.
Learn more about DataGrip’s features.
Join over 600,000 happy PhpStorm users worldwide!
Download PhpStorm