@sqlsmith/core

Core SQL schema merging engine with dependency resolution.

Installation

npm install @sqlsmith/core

Usage

import { SqlMerger } from '@sqlsmith/core';

const merger = new SqlMerger();

// Parse SQL files from directory
const sqlFiles = merger.parseSqlFiles('./schemas', 'postgresql');

// Merge files with options
const merged = merger.mergeFiles(sqlFiles, {
  addComments: true,
  includeHeader: true,
  separateStatements: true,
  outputPath: 'merged.sql' // Optional: write to file
});

console.log(merged); // Merged SQL content

Features

• ✅ Smart dependency detection - Analyzes FOREIGN KEY constraints
• ✅ Topological sorting - Safe execution order using Kahn's algorithm
• ✅ Circular dependency detection - Prevents invalid schemas
• ✅ Multi-dialect support - PostgreSQL, MySQL, SQLite, BigQuery
• ✅ Sequences & Views - Handles CREATE SEQUENCE and CREATE VIEW statements
• ✅ TypeScript support - Full type safety and IntelliSense

API

SqlMerger

Main class for SQL merging operations.

Processors

• CreateTableProcessor - Handles CREATE TABLE statements
• CreateSequenceProcessor - Handles CREATE SEQUENCE statements
• CreateViewProcessor - Handles CREATE VIEW statements

Processor interface

import type { AST } from 'node-sql-parser'
import type { SqlStatement } from './types/sql-statement'

export interface StatementProcessor {
  getHandledTypes(): string[]
  canProcess(statement: AST): boolean
  extractStatements(ast: AST | AST[], filePath: string): SqlStatement[]
}

Note: pre-release change — the extractStatements method no longer receives a dialect parameter. If you need dialect-specific behavior in a custom processor, pass it via the constructor or configuration when creating the processor.

Services

• DependencyAnalyzer - Analyzes statement dependencies
• TopologicalSorter - Sorts statements by dependencies
• SqlFileParser - Parses SQL files and extracts statements

License

MIT