SQL-related awesome list.
- PoorMansTSqlFormatter - A small free .NET and JS library.
- SQL Formatter - Instant SQL Formatter.
- Alexandria-PLSQL-Utils - Oracle PL/SQL Utility Library.
- PLSQL-JSON - The JSON encode/decode library for Oracle PL/SQL.
- Oracle SQL Developer - A free, integrated development environment.
- SQL Tools for Oracle - A light weight and robust frontend for Oracle database development.
- Testing Framework for PL/SQL - An open-source testing framework for PL/SQL and SQL.
- Oracle Database 18c Express Edition - Free Oracle Database for everyone.
- Oracle Database Online Documentation 12c - Documentation, release 1 (12.1).
- SQL Server Data Tools - A modern development tool for building SQL Server relational databases, Azure SQL Databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports.
- SQL Server 2019 - SQL Server 2019 by Microsoft.
- Database Unit Testing for SQL Server - Unit testing framework for SQL Server.
- SQL Server Architecture - Detailed Explanation.
- Learn SQL Server - Detail information related to SQL Server.
- SQL Server Interview Questions - Prepare for SQL interview with these most asked real-world SQL interview questions.
- sqruff - A SQL linter and formatter written in Rust that supports various SQL dialects and integrates with VSCode through a plugin.
- sqlaxe - CLI tool for searching, filtering, formatting, and splitting SQL files. Supports 40+ dialects of SQL.
- BigBash - A converter that generates a bash one-liner from an SQL Select query.
- ERAlchemy - Entity Relation Diagrams generation tool.
- Flyway - Version control for a database.
- Rumba RDBM - Database schema migration tool, plain-SQL, and declarative schema definition supported.
- Liquibase - Manage database changes with ease.
- PixQL - SQL for image processing.
- SQL Fiddle - A tool for easy online testing and sharing of database problems and their solution.
- SQLPad - A web app for writing and running SQL queries and visualizing the results.
- EverSQL - Automated query optimizer, performance monitor and analyser, powered by AI.
Other awesome links & resources!
- W3Schools - SQL Tutorial with W3Schools.
- CodecAcademy - CodecAcademy (Learn SQL).
- SQLZoo - SQL Tutorial.
- Scaler Topics - Learn basic and advanced concepts of SQL.
- InetrviewBit - Learn SQL: Basic to Advanced Concepts.
- SQL Day - SQLDay is the largest conference focused on Microsoft Data Platform – databases, Big Data, Business Intelligence and advanced data analysis.
Protection, hardening, security.
- OWASP SQL Injection Prevention Cheat Sheet - Practical guidance on how to prevent SQL injection via parameterization, input validation, etc.
- OWASP Injection Prevention Cheat Sheet - Broader view on injection flaws (not just SQL) and mitigation strategies.
- OWASP Database Security Cheat Sheet - Advice on secure configuration of SQL / NoSQL systems and database-level defenses.
- OWASP: Testing for SQL Injection (WSTG) - How to test applications for SQL injection vulnerabilities.
- MITRE CAPEC-66: SQL Injection - Entry in CAPEC (Common Attack Pattern Enumeration & Classification) describing SQLi attack patterns.
- CWE-20: Improper Input Validation - Entry in CWE by MITRE about Improper Input Validation.
Warmly welcome! Kindly go through Contribution Guidelines first.
Examples of behavior that contributes to creating a positive environment include:
Using welcoming and inclusive language
Being respectful of differing viewpoints and experiences
Gracefully accepting constructive criticism
Focusing on what is best for the community
Showing empathy towards other community members