AI DBA

Search titles, article text, and tags.

    Consulting

    Three ways to get an outside opinion

    Fixed-scope reviews and assessments of systems already in production, each with a defined question to answer and a defined thing you receive at the end. Not staff augmentation, and not an ongoing retainer.

    Architecture Review

    For teams running a database or data platform they did not design, or that has outgrown the design it started with.

    Enquire about this

    Problems it addresses

    • No one currently owns the question of whether the architecture still fits the load it carries.
    • An early design decision has become expensive, and it is not clear which one.
    • A rebuild is being considered and nobody outside the team has challenged the plan.

    What you receive

    • An executive summary of the key risks, constraints, and decisions.
    • A technical review with prioritized findings and actionable recommendations.
    • A target architecture, roadmap, and supporting documentation where needed.

    Format

    A discovery call defines the scope. We work with the access and materials your policies allow, then present and discuss the findings with your team.

    CDC Architecture Assessment

    For teams moving change data from PostgreSQL into ClickHouse through Kafka and Debezium, or planning to.

    Enquire about this

    Problems it addresses

    • Rows in the destination do not match the source, and nobody can say when they diverged.
    • The pipeline has never been taken through a failover, a schema change, or a replay.
    • Consumer lag is monitored, but retained WAL and reconciliation are not.

    What you receive

    • An end-to-end assessment of the CDC pipeline and its failure modes.
    • A validated architecture with prioritized fixes, testing, and operational recommendations.
    • Where implementation is included, a tested CDC pipeline taken through to the agreed working state.

    Format

    We start with the problem, whether it is an existing pipeline or a new design. Assessment, implementation, and production rollout can be scoped as separate phases.

    PostgreSQL / ClickHouse Production Assessment

    For teams whose database is in production and now carries load the original design never anticipated.

    Enquire about this

    Problems it addresses

    • Query performance degrades in ways that are hard to attribute to a cause.
    • High availability exists on paper but has not been exercised under real failure.
    • Operational risk is concentrated in one person's knowledge of the system.

    What you receive

    • An executive view of the main reliability, performance, and operational risks.
    • A detailed technical assessment with prioritized findings and concrete remediation steps.
    • Documentation, architecture changes, runbooks, or automation where required by the scope.

    Format

    The scope can range from one production problem to a broader platform review. We can work from supplied data, screen sharing, or read-only access and finish with a review session for your team.

    Not sure which one fits

    Describe the system and the problem you are seeing. If none of these is the right shape, saying so is free.

    Start a conversation