stmtk is a CLI tool designed for the hard problems of SQL statement analysis. It sits between your terminal and your database, acting as a linter, a parser, and a profiler all in one.
Property managers receiving rent rolls and bank statements for 500+ units can use the STMTK tool to match tenant deposits with lease IDs, flagging late payments without a single spreadsheet.
statement_type: "bank" date_format: "%m/%d/%Y" encoding: "UTF-8" field_mapping: - source_pattern: "Deposits and credits" target_field: "credit" - source_pattern: "Withdrawals and debits" target_field: "debit" extraction_rules: - name: "balance_check" expression: "(opening_balance + total_credits - total_debits) == closing_balance"
stmtk is a CLI tool designed for the hard problems of SQL statement analysis. It sits between your terminal and your database, acting as a linter, a parser, and a profiler all in one.
Property managers receiving rent rolls and bank statements for 500+ units can use the STMTK tool to match tenant deposits with lease IDs, flagging late payments without a single spreadsheet.
statement_type: "bank" date_format: "%m/%d/%Y" encoding: "UTF-8" field_mapping: - source_pattern: "Deposits and credits" target_field: "credit" - source_pattern: "Withdrawals and debits" target_field: "debit" extraction_rules: - name: "balance_check" expression: "(opening_balance + total_credits - total_debits) == closing_balance"