Tools that help when working with databases.
Docker Compose sets up a development environment with many types of databases. sqlc auto-generates boilerplate SQL and keeps it type-safe. AskDB scans a database and generates queries with an LLM. jason simplifies database management and reduces the complexity of handling data. Dingo is an open-source distributed system that provides services and tools for managing and processing big data. RunSQL offers a web interface for writing and running queries, and for SQL practice on MySQL, PostgreSQL, and SQL Server.
Development & Setup
- Docker Compose: Set up a development environment with many types of databases - Reference
Query Builders & Code Generation
- sqlc: Auto-generates boilerplate SQL queries, type-safe - Website
- AskDB: Scans a database and generates queries with an LLM - GitHub
- jason (aurijs/jason): A tool that simplifies database management and reduces the complexity of handling data - GitHub
- Dingo: Open-source distributed system providing services and tools for managing and processing big data - GitHub
Online Tools
- RunSQL: Online environment for running SQL queries on database systems such as MySQL, PostgreSQL, and SQL Server
- Supports SQL practice and learning
- Intuitive web interface for writing and running queries
- Website: https://runsql.com/ #SQL #online #database #practice
See also: SQL Optimization · PostgreSQL · MySQL