Database Support
Database Support
Supported databases and their features
Database Support
data-peek currently supports PostgreSQL and MySQL, with SQLite coming soon.
Supported Databases
| Database | Status | Features |
|---|---|---|
| PostgreSQL | ✓ Full Support | All features |
| MySQL | ✓ Supported | Core features |
| SQLite | Coming Soon | - |
Feature Comparison
| Feature | PostgreSQL | MySQL |
|---|---|---|
| Query execution | ✓ | ✓ |
| Schema explorer | ✓ | ✓ |
| Table preview | ✓ | ✓ |
| Inline editing | ✓ | ✓ |
| Table designer | ✓ | ✓ |
| ER diagrams | ✓ | ✓ |
| Query plans (EXPLAIN) | ✓ | ✓ |
| EXPLAIN ANALYZE | ✓ | - |
| Sequences | ✓ | - |
| Custom types (enums) | ✓ | ✓ |
| JSON support | ✓ | ✓ |
| Array types | ✓ | - |
Connection Security
Both databases support:
- SSL/TLS connections
- Password authentication
- Encrypted credential storage