Portbase vs DBKit

Portbase is a database client for MySQL, MariaDB, PostgreSQL, MongoDB, SQLite, Redis, ClickHouse and Elasticsearch on iPhone and iPad. • SQL consoles with autosaved drafts, completion, formatting, Explain and execution at the cursor. • Browse supported schemas, views, indexes, keys and DDL; follow related SQL rows. • Resize, pin, hide and sort result columns. Select and copy cell ranges. • MongoDB Find, Aggregation and Command editors with typed BSON document editing, table views and charts. • Create local SQLite databases or import a consistent snapshot. Files stay on this device. • Browse Redis keys with SCAN; inspect strings, hashes, lists, sets, sorted sets and streams; manage expiration and reviewed writes. • Query ClickHouse over HTTP(S). Inspect Elasticsearch mappings, search documents and aggregations. • Inspect chart points, filter dates, open matching loaded rows and export PNG/PDF. • Save unlimited connections, queries and charts, with Trash and recovery. • TLS and SSH connection options. Connection secrets stay in this device’s Keychain. Operations vary by engine. Manual Commit/Rollback is available for MySQL, MariaDB and PostgreSQL. CSV/JSON import and full query export are available for MySQL, MariaDB, PostgreSQL, MongoDB and SQLite; other engines export loaded results. Tables display up to 10,000 rows. Charts inspect loaded results; full exports respect the query’s filters and limits. MongoDB document editing requires MongoDB 4.2 or later and a transaction-capable replica set or sharded cluster. Redis supports standalone endpoints, without Cluster/Sentinel discovery or scripting. SQLite commands commit individually; manual console transactions and temporary objects are unavailable.

DBKit is a professional SQL database client for iPhone and iPad, built for developers, DBAs, DevOps engineers, backend engineers, data analysts, QA engineers, IT professionals, and SQL learners. Connect directly to SQLite, MySQL, and PostgreSQL databases from your mobile device. Run SQL queries, browse schemas, inspect tables, analyze data, and export results securely wherever you are. Whether you are troubleshooting production issues, checking application data, validating SQL statements, reviewing database structures, or learning SQL, DBKit provides a fast and efficient database experience optimized for iPhone and iPad. ## Supported Databases • SQLite • MySQL • PostgreSQL ## Direct Database Connections Connect directly from your iPhone or iPad to your own database servers. • No cloud relay services • No proxy servers required • No additional infrastructure needed • Supports local and remote connections • Credentials remain under your control DBKit is designed for secure direct database access without relying on intermediary services. ## SQL Editor Write, edit, and run SQL queries from a mobile-optimized editor. • SQL syntax highlighting • Intelligent auto-completion • Query history • Multi-statement execution • Fast query execution • Easy editing and copying DBKit helps you work efficiently whether you are writing simple queries or complex SQL statements. ## Database Explorer Browse and inspect database structures. View: • Tables • Columns • Indexes • Foreign keys • Constraints • Triggers • Schemas Understand your database structure without needing a desktop database tool. ## Data Viewer & Export Inspect query results directly on your device. • Browse records • View large result sets • Explore table contents • Analyze query results • Identify data issues quickly Export results in multiple formats: • CSV • TSV • JSON • SQL • Markdown Useful for data backup, migration, documentation, reporting, collaboration, and analysis. ## PostgreSQL Features DBKit supports advanced PostgreSQL workflows: • Transaction management • Parameterized queries • Schema introspection • Constraint inspection • Trigger inspection • SSL connections Designed for development, testing, administration, and operational workflows. ## Security & Privacy • Credentials are stored securely using Apple Keychain • No plaintext password storage • No third-party relay servers • Direct device-to-database communication • SSL encrypted connections where supported Your database connection information remains stored locally on your device. DBKit does not provide database hosting or act as an intermediary between you and your databases. ## Built for Professionals DBKit is suitable for: • Software developers • Database administrators • DevOps engineers • Backend engineers • Data analysts • QA engineers • Operations engineers • IT professionals • SQL learners Whether you are at the office, working remotely, traveling, on site, or responding to a production incident, DBKit helps you stay productive wherever your work takes you. ## In-App Purchases DBKit offers monthly, yearly, and lifetime purchase options. Subscriptions auto-renew unless canceled at least 24 hours before renewal. You can manage or cancel subscriptions in your App Store account settings. EULA: https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Privacy Policy: https://leotan1990.github.io/databases/AppStore/privacy_en.html ## Disclaimer DBKit is an independent third-party database client and is not affiliated with, endorsed by, or sponsored by MySQL, PostgreSQL, SQLite, MongoDB, Redis, or their respective owners. MySQL®, PostgreSQL®, SQLite®, MongoDB®, and Redis® are trademarks or registered trademarks of their respective owners. DBKit does not provide database hosting services. Users are responsible for configuring, maintaining, and securing their own database servers, credentials, network access, and database environments.