LiorCohen/sdd / plugin/fullstack-typescript/skills/components/backend/backend-scaffolding
backend-scaffolding
VerifiedScaffolds Node.js/TypeScript backend components with CMDO architecture, driven by component settings.
templates/src/operator/create_database.ts
View on GitHub// Database: Connection factory using PostgreSQL
import { Pool, type PoolConfig } from 'pg';
import type pino from 'pino';
import type { Config } from '../config';
export type Database = {
readonly connect: () => Promise<void>;
readonly query: <T>(sql: string, params?: unknown[]) => Promise<{ rows: T[] }>;
readonly close: () => Promise<void>;
};
type DatabaseDependencies = Readonly<{
readonly config: Config;
readonly logger: pino.Logger;
}>;
export const createDatabase = (deps: DatabaseDependencies): Database => {
const logger = deps.logger.child({ component: 'database' });
// PostgreSQL connection pool
// Configure via DATABASE_URL environment variable
const poolConfig: PoolConfig = {
connectionString: deps.config.databaseUrl,
};
const pool = new Pool(poolConfig);
return {
connect: async () => {
// Test connection
const client = await pool.connect();
client.release();
logger.info('Database connected');
},
query: async <T>(sql: string, params?: unknown[]): Promise<{ rows: T[] }> => {
const result = await pool.query(sql, params);
return { rows: result.rows as T[] };
},
close: async () => {
await pool.end();
logger.info('Database connection closed');
},
};
};
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation). | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK). | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |