SQL Recipes
SQL trainer with a database
Free · In-App Purchases
201 SQL queries with explanations. 122 of them are free, and more than half of all queries run right in the app and show the result table.
An everyday SQL reference, from your first SELECT to window functions. Every query comes with an explanation, and most of them run.
• 39 sections: filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views.
• Run in the app: more than half of the queries execute against a live practice database, and the result table appears below the query. Needs an internet connection.
• Changes in new versions: 7 sections from SQL-92 to SQL:2023, showing what each standard added, with the old and the new query side by side.
• Dialects compared: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately.
• The practice database is the classic MySQL world sample database: countries, cities, languages. The tables are described in the app.
• Edit any query and run it again; one tap brings the original back.
• Add your own queries; they stay in the app and are always at hand.
• Search by section name or by a fragment of a query.
• Everything except running works offline. No account needed.
WHAT THE FREE VERSION INCLUDES
12 runs and 12 edits a day; the limit resets every morning. The keyword reference is unlocked, with no limits. Up to 5 queries of your own.
The full version unlocks every section, lifts the daily limits and raises the run limit to 80 a day. One purchase, no subscription.
Built by a developer for developers. In active development since 2015.
Ratings & Reviews
- This app has not received enough ratings or reviews to display an overview.
• Copying code is now unlocked in the free version too, with no limit.
• Supports iOS 17 and macOS 14.
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
- Size
- 4.7 MB
- Category
- Developer Tools
- 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 0,99 €
- Оperations with example 0,99 €
- Pro Version – Unlimited 1,99 €
- Provider
Fedor Obraztsov
- Fedor Obraztsov has not identified itself as a trader for this app. If you are a consumer in the European Economic Area, consumer rights do not apply to agreements between you and the provider.
- Copyright
- © Fedor Obraztsov