Skip to content

Security: Schema-Smith/SchemaSmith

Security

SECURITY.md

Security Policy

Supported Versions

Version Supported
2.x Yes
1.x No

v2.0 is feature-complete across all three platforms (SQL Server, PostgreSQL, MySQL) and replaces v1 with no upgrade cost. v1.x is no longer maintained.

Reporting a Vulnerability

Do not open a public issue for security vulnerabilities.

Instead, please report security issues by emailing security@schemasmith.com with:

  • Description of the vulnerability
  • Steps to reproduce
  • Affected tool(s) and version(s)
  • Impact assessment if known

You should receive an acknowledgment within 48 hours. We will work with you to understand the issue and coordinate a fix before any public disclosure.

Scope

SchemaSmith tools connect to SQL Server, PostgreSQL, and MySQL databases and execute SQL. Security-relevant areas include:

  • Connection credential handling — passwords are redacted in logs, but configuration files may contain credentials
  • SQL generation — tools generate and execute dynamic SQL against target databases
  • File handling — tools read schema packages from disk or ZIP archives

Best Practices

  • Prefer your platform's strongest non-password authentication over storing credentials in config files: Windows integrated authentication or Azure AD on SQL Server, Kerberos / GSSAPI or SCRAM-SHA-256 on PostgreSQL, socket auth or PAM auth on MySQL
  • Restrict file system permissions on configuration files containing credentials
  • Use environment variables (SmithySettings_ prefix) for sensitive settings in CI/CD pipelines
  • Review WhatIf output before applying changes to production databases

There aren't any published security advisories