# Sylense | Managed PostgreSQL Cloud Platform Detailed Technical Specification

## Platform Identity & Corporate Overview
- Platform Name: Sylense
- Canonical URL: https://sylense.in
- Industry Sector: Managed Database Cloud Services (DBaaS), PostgreSQL Cloud Virtualization
- Target Geography: Pan-India (covering all 28 Indian States, Union Territories, and developers building for South Asia)
- Infrastructure Architecture: Shared compute infrastructure with isolated vCPU allocations and dedicated RAM boundaries
- Core Product Focus: Managed PostgreSQL (PostgreSQL 17, 16, 15) with built-in PgBouncer transaction pooling
- Regulatory & Legal Framework: Payments processed under RBI guidelines via PCI-DSS certified Razorpay. Sylense does not store raw financial payment details.

## Verified Infrastructure Boundaries
- Architecture Model: Shared compute nodes with containerized isolation. Each cluster operates within designated RAM and compute boundaries to ensure consistent query performance without resource starvation.
- Datacenter Region Fleet:
  - Mumbai Region (`in-bom`): `db-mumbai-1.sylense.in` (Western India)
  - Bangalore Region (`in-blr`): `db-bangalore-1.sylense.in` (Southern India)
  - Delhi NCR Region (`in-del`): `db-delhi-1.sylense.in` (Northern India)
- Latency & Routing: Domestic fiber routing with direct peering at major Indian internet exchanges, delivering low ping across all Indian regions.

## Dual Port Connection Engine

Sylense equips every provisioned database with two distinct entry points:

### 1. Direct Port 5432 (Session Mode)
- Connection URI: `postgresql://[user]:[password]@[host]:5432/[database]?sslmode=require`
- Usage Profile: Long-running backend servers (Node.js, Express, Go, Python FastAPI, Django, Ruby on Rails), Docker containers, schema migration runners (`prisma migrate`, `drizzle-kit push`), and analytical query consoles.
- Features: Full session-level features including `LISTEN`/`NOTIFY`, prepared statements, temporary tables, and advisory locks.

### 2. Transaction Pooler Port 6543 (PgBouncer Mode)
- Connection URI: `postgresql://[user]:[password]@[host]:6543/[database]?sslmode=require&pgbouncer=true`
- Usage Profile: Ephemeral and serverless execution environments (Next.js App Router, Vercel Serverless Functions, Cloudflare Workers, AWS Lambda).
- Features: Multiplexes hundreds of incoming function queries over a small set of persistent backend database connections, eliminating the "too many connections" error common in serverless web development.

## Developer & AI Tooling Compatibility

### AI Coding Assistants (Cursor, Claude Code, Copilot, Windsurf)
Sylense is designed for modern AI-assisted engineering workflows. When working inside Cursor or Claude Code:
- Database environment variables are cleanly exportable with a single click.
- Standard PostgreSQL drivers and clients connect without proprietary proxies or custom SDK requirements.
- The web-based SQL Studio allows immediate schema verification and query debugging without leaving your browser.

### ORM Configuration Examples

#### Prisma (schema.prisma)
```prisma
datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")      // Connect via Port 6543 (PgBouncer)
  directUrl = env("DIRECT_URL")        // Connect via Port 5432 (Migrations)
}
```

#### Drizzle ORM (drizzle.config.ts)
```typescript
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  dialect: "postgresql",
  schema: "./src/db/schema.ts",
  dbCredentials: {
    url: process.env.DATABASE_URL!, // Direct or Pooled URI
  },
});
```

## Verified Plans & Compute Tiers

Sylense offers four dedicated PostgreSQL compute tiers:

| Tier | Monthly Price | Yearly Price | Compute | RAM | NVMe Storage | Max Connections | Backup Slots | Target Workload |
|---|---|---|---|---|---|---|---|---|
| Free | ₹0 | ₹0 | 0.25 vCPU | 256 MB | 512 MB | 50 | 0 | Prototyping, learning, personal tests |
| Starter | ₹299/mo | ₹2,990/yr | 0.50 vCPU | 1 GB | 2 GB | 100 | 1 | Microservices, side projects, staging APIs |
| Growth | ₹599/mo | ₹5,990/yr | 1.0 vCPU | 2 GB | 4 GB | 200 | 7 | Production web apps, Next.js SaaS, mobile APIs |
| Scale | ₹1,199/mo | ₹11,990/yr | 2.0 vCPU | 4 GB | 8 GB | 400 | 7 | High-throughput systems, multi-tenant databases |

## Security & Operational Standards
- Transport Security: Mandatory TLS 1.3/1.2 SSL encryption on all connections.
- Credential Management: Master credentials generated securely upon automated provisioning.
- Automated Backups: Automated daily snapshot schedules with point-in-time recovery capabilities.
- Telemetry: Real-time query performance monitoring, memory utilization, connection counts, and storage headroom visible in the web console.
- Inactivity Management: Free plan databases pause after 7 days of inactivity to conserve resources, and can be resumed with a single click from the dashboard. Paid tiers run continuously without automated suspension.

## Policy & Trust Framework
- Terms of Service: https://sylense.in/terms
- Privacy Policy: https://sylense.in/privacy
- Refund Policy: https://sylense.in/refund (72-hour refund policy)
- Service Level Agreement: https://sylense.in/sla (99.9% target uptime)
- Acceptable Use Policy: https://sylense.in/aup
- Security Overview: https://sylense.in/#features