Movatterモバイル変換

Jump to content

List of SQL software and tools

From Wikipedia, the free encyclopedia

SQL software and development tools

This is a list of software andprogramming tools for theSQL language, includingRDBMSs,database clients,IDEs,Database administration tools,migration tools, and related projects.

Relational database management systems (RDBMSs)

Main articles:Comparison of relational database management systems andList of relational database management systems

Database clients and management tools

See also:Comparison of database administration tools

Database migration and version control

Flyway — database migration tool
Liquibase — databaseschema change management^[1]

Data modeling tools

ER/Studio — data modeling and architecture tool fromIDERA
erwin Data Modeler — data modeling software
PowerDesigner – data modeling anddata Warehouse^[2]

SQL IDEs and development tools

Application Development System Online (ADSO) — 4GL and development environment for IDMS databases
DataGrip — SQL IDE byJetBrains
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 ofPL/SQL stored-program units
SQLyog
SQuirreL SQL Client
Toad — IDE and management tool for various RDBMSs^[3]
SynapseDBA - SQL/NoSQL Database IDE viaODBC^[4]

Database drivers andORMs

See also:List of object–relational mapping software

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 SQLOLAP database for analytics
Metabase — open-sourcebusiness 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

pgBackRest — open-sourcePostgreSQL backup and restore tool
Oracle Data Guard — high availability and disaster recovery
SymmetricDS — database replication and synchronization^[7]

See also

DB-Engine Ranking list
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

Wikibooks has a book on the topic of:Structured Query Language

External links

v t e SQL
Versions	SEQUEL SQL-86 SQL-89 SQL-92 SQL:1999 SQL:2003 SQL:2006 SQL:2008 SQL:2011 SQL:2016 SQL:2023
Keywords	As Case Create Delete From Group by Having Insert Join Merge Null Order by Over Prepare Select Truncate Union Update With
Related	Edgar Codd Relational database
ISO/IEC SQL parts	Framework Foundation Call-Level Interface Persistent Stored Modules Management of External Data Object Language Bindings Information and Definition Schemas SQL Routines and Types for the Java Programming Language XML-Related Specifications

v t e Database management systems
Types	Object-oriented comparison Relational list comparison Key–value Column-oriented list Document-oriented Wide-column store Graph NoSQL NewSQL In-memory list Multi-model comparison Cloud Blockchain-based database
Concepts	Database ACID Armstrong's axioms Codd's 12 rules CAP theorem CRUD Null Candidate key Foreign key PACELC design principle Superkey Surrogate key Unique key
Objects	Relation table column row View Transaction Transaction log Trigger Index Stored procedure Cursor Partition
Components	Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query rewriting system Query plan
Functions	Administration Query optimization Replication Sharding
Related topics	Database models Database normalization Database storage Distributed database Federated database system Referential integrity Relational algebra Relational calculus Relational model Object–relational database Transaction processing List of SQL software and tools
Category Outline

References

^"Liquibase vs Flyway | Baeldung".www.baeldung.com. 2022-04-13. Retrieved2025-09-20.
^"Data Modeling Tools Comparison: Top Picks for 2024 | Orchestra".www.getorchestra.io. Retrieved2025-09-20.
^"52 SQL Editors and IDEs Compared (2020): The Ultimate List".www.databasestar.com. Retrieved2025-09-20.
^"SynapseDBA | Database IDE".SynapseDBA. Retrieved2025-10-05.
^"Apache Superset vs Tableau, Power BI, Metabase – which BI tool to choose for e-commerce analytics?".www.attomy.io. Retrieved2025-09-20.
^"pgbench".PostgreSQL Documentation. 2025-08-14. Retrieved2025-09-20.
^"Data Synchronization for Edge Computing with SymmetricDS".freeCodeCamp.org. 2025-03-13. Retrieved2025-09-20.

Retrieved from "https://en.wikipedia.org/w/index.php?title=List_of_SQL_software_and_tools&oldid=1334713689"

Hidden categories:

[8]ページ先頭

©2009-2026 Movatter.jp