# AnyData - Design your database — Custom databases on device

> Custom databases on device (iPhone/iPad app by SIU LO.)

- Source: https://appshunter.io/ios/app/anydata-design-your-database/id6798812790 (this page in markdown: same URL + `.md`)
- Developer: [SIU LO](https://appshunter.io/developer/380878489)
- Category: Productivity, Developer Tools
- Price: Free
- Age rating: 4+
- Requires: iOS 26.5 · 7 MB
- Languages: American English
- Released: 2026-08-19
- Data updated: 2026-08-22
- User reviews in markdown: https://appshunter.io/ios/app/anydata-design-your-database/id6798812790/reviews.md

## What is AnyData?

AnyData lets you design a custom database on your iPhone or iPad—no account and no cloud required.

BUILD YOUR SCHEMA
• Workspaces keep separate databases on the same device
• Enumerables define reusable pick lists (unique values, deletable)
• Classes define tables with typed properties: String, Date/Time, Date, Time, Integer, Float, Color, Enumerable, and Class references
• All properties are optional

ENTER DATA
• Edit instances with constrained controls (pickers, number pads, date/time, color)
• Forms provide a clean, class-bound entry UI—Submit saves and clears for the next record

EXPLORE WITH VIEWS
• Create views on one or more classes
• Choose output columns (shown as Class › Field)
• Optional filters (AND/OR) with typed comparators
• Optional GROUP BY with Count, Sum, Average, Min, Max, and Median
• Related classes join on Class references; unrelated classes use a Cartesian product
• Sortable tables with Class drill-down into record details

UNDERSTAND STRUCTURE
• Interactive ER Diagram—drag tables, pinch to zoom, Auto Layout, export PNG or PDF
• Generate Sample creates an Oracle HR–inspired demo schema, views, and forms

EXPORT
• Export ANSI SQL DDL (tables, primary/foreign keys, views)
• Export data as INSERT statements
• Export data as CSV (zipped per-table files)
• Share via the system share sheet

Privacy-friendly: data stays on your device using on-device storage. Light and Dark Mode supported.


## Version history (last 1 release)

### 1.0 — 2026-08-19

No release notes.

## More apps by SIU LO

- [HK Weather](https://appshunter.io/ios/app/hk-weather/id547912170)
- [HKG Flights](https://appshunter.io/ios/app/hkg-flights/id880156759)
- [粵音字典](https://appshunter.io/ios/app/id914343832)
- [香港小學學習字詞表](https://appshunter.io/ios/app/id1213923119)
- [Day Log - your log of the day](https://appshunter.io/ios/app/day-log-your-log-of-the-day/id6755245087)
- [My Days - Journals](https://appshunter.io/ios/app/my-days-journals/id6773829577)

All apps by SIU LO: https://appshunter.io/developer/380878489

---

*Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2026-08-22.*