Software:List of SQL software and tools

From HandWiki
Short description: SQL software and development tools

This is a list of software and programming tools for the SQL language, including RDBMSs, database clients, IDEs, Database administration tools, migration tools, and related projects.

Relational database management systems (RDBMSs)

Database clients and management tools

Database migration and version control

Data modeling tools

SQL IDEs and development tools

  • Application Development System Online (ADSO) — 4GL and development environment for IDMS databases
  • DataGrip — SQL IDE by JetBrains
  • DbForge Studio – query building, data editing, debugging, and database management tools.
  • Oracle SQL Developer — IDE for Oracle Database
  • PL/SQL Developer – Oracle database environment that focuses on the development of PL/SQL stored-program units
  • Toad — IDE and management tool for various RDBMSs[3]
  • SynapseDBA - SQL/NoSQL Database IDE via ODBC[4]

Database drivers and ORMs

  • JDBC — Java database connectivity
  • ODBC — Open Database Connectivity
  • SQLAlchemy — Python SQL toolkit and ORM
  • Hibernate — Java ORM framework
  • Doctrine — PHP ORM framework
  • Entity Framework — .NET ORM framework
  • ActiveRecord — Ruby ORM framework

Data analysis and business intelligence

  • DuckDB — in-process SQL OLAP database for analytics
  • Metabase — open-source business intelligence tool
  • Tableau — data visualization and analysis
  • Power BI — Microsoft business intelligence platform
  • Apache Superset — modern data exploration and visualization platform
  • Redash — open-source query and visualization platform
  • Vertica — columnar SQL database optimized for data warehousing and large-scale analytics[5]

Testing and performance tools

  • HammerDB — load testing and benchmarking tool for databases
  • pgbench — PostgreSQL benchmarking tool[6]

Backup, replication, and high availability

See also

  • DataFlex — programming language and development environment for business applications with support for SQL databases
  • Microsoft Visual FoxPro — programming language and database system with SQL-like query support

References