Practical notes on scheduled SQL exports, living database documentation, shared SQL queries, and the private agent boundary.
Azure SQL Database has no default trace and no server DDL triggers. Audit schema changes with database triggers, Azure SQL Auditing or Extended Events.
Read guideAzure SQL Database has no Database Mail and no SQL Agent. Real options to email query results as CSV on a schedule, from Logic Apps to an agent.
Read guideAutomate a recurring SQL to CSV export on SQL Server, PostgreSQL, MySQL, Azure SQL and Redshift: native options, where each breaks, what is simpler.
Read guideflyway validate checks migration files, not the live schema. What Flyway and Liquibase drift checks see, what they miss between deploys, and how to watch it.
Read guideGenerate a MySQL data dictionary from information_schema.COLUMNS with column comments, export it to CSV, and keep it accurate after every ALTER TABLE.
Read guideMySQL has no DDL triggers. How to find who changed a table and when: binary log, general log, audit plugins, information_schema and schema snapshots.
Read guideThe MySQL Event Scheduler cannot email and INTO OUTFILE is blocked by secure_file_priv and on RDS. Working ways to send query results as CSV.
Read guidePopSQL was due to shut down on 1 September 2026, then postponed with limited support only. A practical plan to move saved SQL and scheduled reports.
Read guideGenerate a PostgreSQL data dictionary with one query on pg_catalog and COMMENT ON descriptions, export it with psql, and keep it current as the schema changes.
Read guidePostgreSQL cannot send email and pg_cron cannot attach files. Schedule a query, write a CSV with COPY or psql \copy, and mail it, also on RDS.
Read guideBefore connecting Claude Code, Codex or Cursor to a production database via MCP, decide what the agent may touch. Three access levels, one schema-only.
Read guideEmail SQL Server query results as a CSV file with sp_send_dbmail and SQL Agent: the parameters that matter, the formatting traps, and Express.
Read guideBefore upgrading to SQL Server 2025, capture the schema, check what the new edition drops (SSRS, Express limits), and compare the schema after the upgrade.
Read guideBuild a SQL Server data dictionary from sys.columns and MS_Description extended properties, export it, and keep it from going stale after the next release.
Read guideSQL Server Express has no SQL Agent. Schedule a query and email the result as CSV with Task Scheduler, sqlcmd and PowerShell, and what breaks later.
Read guideConnecting Claude Code, Codex or Cursor to SQL Server through MCP: Microsoft's SQL MCP Server in Data API builder, read-only setups, and a schema-only option.
Read guideFour ways to see schema change history in SQL Server: default trace, DDL triggers, Extended Events and snapshots, and how much history each keeps.
Read guideSQL Server 2025 ships without SSRS. How to replace subscriptions that only email a CSV or Excel file, without moving to Power BI Report Server.
Read guideFour ways to track schema changes in PostgreSQL: event triggers, log_statement, pgaudit and catalog snapshots. What each one records and what it misses.
Read guideTeams building AI assistants on top of private databases keep reinventing the same schema catalog, and the catalog goes stale by week three. What that layer needs to have to survive, and why almost nobody has it.
Read guideTraditional database observability tools watch queries, connections and locks. They miss the moment the schema itself changes. Why structural change deserves to be a first-class signal, and how to add that layer to what you already run.
Read guideSchema drift is the gap between the schema your code expects and the one you run. Where it opens, why migrations do not close it, how to detect it.
Read guideA practical guide to parameterized SQL queries for operations teams. What becomes a variable, how defaults and overrides work, how to audit each run, and how to schedule the query safely against private MySQL and PostgreSQL databases.
Read guideA workflow to share SQL queries online with your team. Move ad hoc SQL from pgAdmin, Slack and gists into a shared, parameterized, audited team library.
Read guideA shared SQL query library helps teams save, organize, run, and schedule trusted operational SQL instead of losing it in Slack and local files.
Read guideStop copying SQL queries in Slack. How small engineering teams save, share and audit trusted queries in one workspace.
Read guideStop losing important SQL in Slack messages. Save operational queries in a shared workspace, run them through an agent, and schedule recurring exports.
Read guideDocument private databases without exposing credentials. Taavik scans through an on-premise agent and generates documentation for teams.
Read guideDatabase docs go stale in weeks. A practical workflow to keep PostgreSQL, MySQL and SQL Server docs updated by scanning the schema.
Read guideLiving database documentation stays aligned with schema changes by scanning private databases and refreshing generated Markdown documentation.
Read guideA practical comparison of pg_dump, information_schema, dbdocs, Dataedo and Taavik for auto-generating PostgreSQL schema and database documentation.
Read guideDocument SQL Server databases by scanning metadata through a private agent and refreshing team documentation after schema changes.
Read guideAutomate recurring operational SQL reports while keeping database access inside your network. Generate CSV or Excel through a private agent.
Read guideA practical guide to turning recurring SQL into scheduled CSV or Excel email delivery, without exposing direct database access.
Read guideSchedule CSV or Excel exports from private databases without opening database access to the internet. Taavik runs exports through an on-premise agent.
Read guideSend scheduled SQL export results to Slack as a secure download link. Useful for on-call, operations, finance, and data quality checks.
Read guideA SQL query scheduler for teams that need recurring CSV or Excel exports, private agent execution, and visible run history.
Read guideRSS feed: /rss.xml