January 31, 2026
Overview
Introducing Direct PostgreSQL Access for Boltic Databases through Connection string
New Feature
Introducing Direct Boltic Database Access - connect to your Boltic-managed databases using a standard Postgres connection string.
Key Features:
1. Standard Postgres Connectivity
- Connect Boltic Database using a Postgres connection string with any ORM, database client, or BI tool - no custom setup required.
2. Managed Infrastructure with Transparent Access
- All traffic flows through a secure architecture:
- Client → Gatekeeper → PgBouncer → Cloud SQL
- Ensuring performance, safety, and isolation.
3. Quota Enforcement
- Platform-level limits are enforced automatically, including write blocking when usage exceeds defined quotas.
4. Connection Pooling at Scale
PgBouncer manages and optimises database connections for high concurrency and efficiency.
5. Secure Access Control
- Connection strings visible only to database creators
- Access scoped per account and database
- Credentials can be reset anytime
- All tables and schema changes are tracked centrally to ensure consistency and governance.
6. User Access & Roles
Access to Boltic Databases is governed through predefined roles:
- Admin - Full database privileges (schema and data operations)
- Executive - Read/write access to tables and records
- Viewer - Read-only access to tables and records
This ensures controlled collaboration with clear separation of responsibilities.
How It Works:
- Create a database from the Boltic dashboard
- Copy the Boltic database connection string
- Connect using your preferred tool (PSQL, ORM, BI tool, etc.)
Direct Boltic Database Access brings the power of Postgres into Boltic, so you can work with your data directly while still getting the platform’s control, security, and reliability. This means you can build and ship custom extensions/usecases for Fynd Commerce, Shopify, Wix, Magento, and more without worrying about setting up or maintaining infrastructure.
