SQLMate

SQLMate is a powerful yet elegant SQLite database manager built exclusively for macOS. Whether you’re a developer debugging your app’s database, a data analyst exploring datasets, or managing local SQLite files, SQLMate provides all the tools you need in a native macOS interface.

KEY FEATURES

Browse & Search
• Visual table browser with advanced filtering
• Fast full-text search across all columns
• Sortable columns with visual indicators
• Pagination for large datasets (50, 100, 500 rows per page)
• Recent databases quick access

Edit Data
• Inline row editing with instant save
• Add new rows with intuitive forms
• Delete rows with safety confirmations
• Full support for NULL values
• Handles all SQLite data types (TEXT, INTEGER, REAL, BLOB)

Schema Management
• View complete table structures
• Create new tables with column designer
• Add, edit, and delete columns
• Rename tables and columns
• Manage indexes (create, view, drop)
• View primary keys, NOT NULL, and default values
• Comprehensive constraints editor

SQL Query Editor
• Execute custom SQL queries
• Real-time syntax suggestions
• Query history and logging
• View execution time and rows affected
• Smart autocomplete for tables and columns

Database Operations
• Create new SQLite databases
• Open multiple databases simultaneously
• VACUUM database to reclaim space
• Export data (CSV, JSON, SQL)
• Database file size optimization
• View query execution logs

macOS Integration

• Native SwiftUI interface
• Keyboard shortcuts for common actions (⌘N, ⌘O, ⌘W)
• Multiple windows support
• Recent files menu
• Drag & drop database files
• App Sandbox security
• macOS 26.0+ optimized

Developer Friendly

• Direct SQLite3 C API access
• No external dependencies
• Handles databases from any SQLite-compatible app
• Support for complex queries and transactions
• Debug your app’s database with ease

Privacy & Security

• All data stays on your Mac
• No internet connection required
• App Sandbox protection
• Security-scoped bookmarks for persistent access
• No tracking or data collection (optional analytics)

Perfect For:

• iOS/macOS developers debugging app databases
• Data analysts working with SQLite files
• System administrators managing local data
• Students learning SQL and database concepts
• Anyone needing to view or edit SQLite databases

SQLMate combines the power of professional database tools with the simplicity of a native Mac app. No complex setup, no learning curve - just open your database and start working.