Skip to content

LiorCohen/sdd / plugin/fullstack-typescript/skills/components/backend/backend-scaffolding

backend-scaffolding

Verified

Scaffolds 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');
    },
  };
};
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: 322kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall