replit-data-handling

name	replit-data-handling
description	Implement secure data handling on Replit: PostgreSQL, KV Database, Object Storage, and data security patterns. Use when handling sensitive data, connecting databases, implementing data access patterns, or ensuring secure data flow in Replit-hosted applications. Trigger with phrases like "replit data", "replit database", "replit PostgreSQL", "replit storage", "replit data security", "replit GDPR".
allowed-tools	Read, Write, Edit
version	1.12.0
license	MIT
author	Jeremy Longshore <[e-mail]>
tags	["saas","replit","database","storage","security"]
compatibility	Designed for Claude Code

Replit Data Handling

Overview

Manage application data securely across Replit's three storage systems: PostgreSQL (relational), Key-Value Database (simple cache/state), and Object Storage (files/blobs). Covers connection patterns, security, data validation, and choosing the right storage for each use case.

Prerequisites

• Replit account with Workspace access
• PostgreSQL provisioned in Database pane (for SQL use cases)
• Understanding of Replit Secrets for credentials

Storage Decision Matrix

Need	Storage	API	Limits
Structured data, queries	PostgreSQL	pg npm / psycopg2	Plan-dependent
Simple key-value, cache	Replit KV Database	@replit/database / replit.db	50 MiB, 5K keys
Files, images, backups	Object Storage	@replit/object-storage	Plan-dependent

Instructions

Step 1: PostgreSQL — Secure Connection

// src/services/database.ts
import { Pool, PoolConfig } from 'pg';

function createPool(): Pool {
  if (!process.env.DATABASE_URL) {
    throw new Error('DATABASE_URL not set. Create a database in the Database pane.');
  }

  const config: PoolConfig = {
    connectionString: process.env.DATABASE_URL,
    ssl: { rejectUnauthorized:  }, 
    : ,
    : ,
    : ,
  };

   pool =  (config);

  
  pool.(,  {
    .(, err.);
    
  });

   pool;
}

  pool = ();


   () {
  
   result =  pool.(
    ,
    [userId]
  );
   result.[];

  
  
}