Monthly cost
Free
Popularity
5/5
LLM knowledge
5/5
Difficulty
Medium
#open-source#self-hostable
What MySQL is good at
Strengths
- +Ubiquitous
- +Tons of tools
- +Well-understood ops
Tradeoffs
- −Fewer advanced features than Postgres
Coding-agent prompt
Drop into Claude / Cursor to get idiomatic MySQL code.
You're working with MySQL. The classic open-source RDBMS. Best practices: - Lean on: ubiquitous - Lean on: tons of tools - Lean on: well-understood ops Things to watch for: - Watch out for: fewer advanced features than postgres General guidance: - Canonical docs: https://mysql.com — check here before inventing APIs. - Keep secrets in environment variables, never commit them. - Write TypeScript where the ecosystem supports it; add types to every exported function. - Add tests for the critical paths before declaring the task done. - Read-the-docs is usually faster than guessing — cite the docs page in code comments when you apply a non-obvious pattern.
Beginner's guide to MySQL
In one line: The classic free relational database — runs half the internet.
MySQL is the other big open-source relational database. Like Postgres, it stores rows and columns. Very popular with PHP apps (WordPress runs on MySQL).
Try it in your terminal
brew install mysqlInstall MySQL on macOS.
Browse all categories