SQLpedia

Appearance

AI SQL Assistant

SQLpediaThe SQL Knowledge Resource

A comprehensive, Wikipedia-style SQL knowledge resource for developers, data engineers, and database administrators

Get Started
View on GitHub
SQLpedia
📖

Learn SQL Fundamentals

Start with the basics and build a strong foundation in SQL.

Explore Concepts

🗄️

Browse by Database

Find database-specific documentation and examples.

View Databases

🎯

Common Patterns

Discover proven SQL patterns for real-world scenarios.

See Patterns

🔄

Compare Dialects

Compare SQL syntax across different database systems.

View Comparisons

Try the AI Assistant ​

🤖 SQL AI Assistant

Generate, explain, optimize, or translate SQL queries using AI

Window Functions ​

Window functions are powerful tools for analytics and reporting. Learn how to use them across different SQL dialects.

Learn More →

Common Table Expressions (CTEs) ​

CTEs make complex queries more readable and maintainable. Discover best practices and patterns.

Learn More →

Query Optimization ​

Learn techniques to improve query performance across different database systems.

Learn More →

Database Migrations ​

Planning to migrate from one database to another? Check our comprehensive migration guides.

Learn More →

About SQLpedia ​

SQLpedia is an open-source, community-driven SQL knowledge resource inspired by Wikipedia. It provides comprehensive documentation, examples, and comparisons for multiple SQL dialects, along with AI-powered tools to help you generate, understand, and optimize SQL queries.

Why SQLpedia? ​

  • Comprehensive: Coverage of all major SQL databases and concepts
  • Practical: Real-world examples and patterns from 35+ years of experience
  • Cross-Platform: Easy comparison of SQL dialects side-by-side
  • AI-Enhanced: Built-in AI assistance for query generation and optimization
  • Open Source: Community contributions welcome via GitHub

Contributing ​

SQLpedia is open source and welcomes contributions! You can:

  • Edit any page directly on GitHub
  • Submit new content via pull requests
  • Report issues or suggest improvements
  • Share your SQL knowledge with the community

View Contributing Guidelines →

  • PostgreSQL - The world's most advanced open source database
  • MySQL - The world's most popular open source database
  • SQL Server - Microsoft's enterprise database platform
  • Oracle - Industry-leading enterprise database
  • SQLite - Self-contained, serverless database engine
  • BigQuery - Google's serverless data warehouse
  • Snowflake - Cloud data platform
  • DuckDB - In-process analytical database
  • ClickHouse - Column-oriented database for real-time analytics

Released under the MIT License.

Copyright © 2024-present SQLpedia Contributors