SQL Recipes: Queries, Commands
Learn SQL on a real database
Free · In-App Purchases
A query that looks right does not always work. Every example is checked again and again by programmers and AI, and queries run on a practice database in the app.
200+ SQL queries with explanations, 120+ of them free. Tap Run and see the result table right in the app.
An everyday SQL cheat sheet, from your first SELECT to window functions.
• 39 sections, including filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views.
• Changes by standard: 7 sections from SQL-92 to SQL:2023, with before-and-after queries.
• Keyword and function reference: over 180 articles. Browse, search, or tap a word in a query to open its article.
• Dialects compared: MySQL, PostgreSQL, SQLite, SQL Server, Oracle, Firebird, Access. Where they differ, the dialect-specific variants are shown.
• Practice database: the classic MySQL “world” sample (countries, cities, spoken languages); its tables are described in the app.
• Run in the app: more than half of the queries execute against the practice database, and the result table appears directly below the query. Requires an internet connection.
• Search covers the queries themselves, not just titles: type a fragment you remember and find the query.
• Edit queries and rerun the runnable ones; one tap brings the original back.
• Add your own queries; they are saved in the app.
• Everything except running queries works offline. No account needed.
Queries are curated from professional sources and checked before release: the code works and is easy to follow.
FREE VERSION
• 12 runs and 12 edits a day
• Full keyword and function reference; tap a word in a query for up to 12 articles a day
• Up to 5 queries of your own
The full version unlocks every query, removes the limits on edits and on your own queries, and raises the daily run limit to 80. One-time purchase, no subscription.
Built by a developer for developers. The CodePro project has been in active development since 2015.
Ratings & Reviews
- This app has not received enough ratings or reviews to display an overview.
• After you run a query you see one result, not two identical tables.
• Code comments in the examples now follow the app language: Russian and Chinese added.
• iPhone in landscape: the buttons sit at the screen edge, leaving more room for code.
• Faster search, example pages and launch.
The developer, Fedor Obraztsov, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .
Data Not Collected
The developer does not collect any data from this app.
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More
Information
- Provider
- Fedor Obraztsov
- Size
- 6.6 MB
- Category
- Education
- Compatibility
Requires iOS 17.0 or later.
- iPhone
Requires iOS 17.0 or later. - iPad
Requires iPadOS 17.0 or later. - Mac
Requires macOS 14.0 or later.
- iPhone
- Languages
English and 14 more
- English, Arabic, French, German, Hebrew, Indonesian, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese, Spanish, Turkish, Vietnamese
- Age Rating
4+
- 4+
- In-App Purchases
Yes
- Unlock the paid topics USD 0.99
- Оperations with example USD 0.99
- Pro Version – Unlimited USD 1.99
- Copyright
- © Fedor Obraztsov
