CASE STUDY DOWNLOAD
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
SQL mIGRATION tOOL desarrollada por 2am.tech

Automatizaciones de Bases de Datos

By
This is some text inside of a div block.
This is some text inside of a div block.
6 min read
If you put five developers on five different AI coding tools, chances are you’ll get five different results from the same ticket. Each team member uses a different set of prompts and has developed different habits while using a given AI agent. One person will paste the requirements into a chat window by hand. Another might neglect the acceptance criteria specified in a Confluence page. AI is certainly capable of writing something plausible, but it's often forced to guess the context that was one tab away the whole time.

Helper AI

¿Para quién es?

SMT es una herramienta práctica para:model actually understands the work, regardless of how great it is. Every developer ultimately ends up building their own prompts, their own conventions and shortcuts, and their own way of copying a ticket into a chat window. The problem with this is inconsistent output and no reliable way to know why one developer's AI-assisted work looks different from another's.

HAI simply makes the tools your team already has work better together. It favors consistency over convenience: everyone needs to agree to a single way of working up front. The benefits are stronger: the whole team gets the same context, the same tooling, and far fewer inconsistent results to untangle later.

HAI’s Features

  • HAI adapts itself to your project and the AI tools your team already uses. After setup, it provides a command to tailor the prompts and agents to your project's structure and code, avoiding the use of generic text. It configures itself inside your AI coding agent of choice and matches each tool's own configuration, so nothing has to be done by hand. Teams without a strong editor preference can also rely on HAI's general setup, which works anywhere.Escribes exactamente lo que se ejecuta; por lo tanto, no hay sorpresas con el SQL generado
  • Turns tickets and specs into something AI can use. Jira issues and Confluence pages get pulled down as readable text files, comments, links, and structure included. If a ticket references other tickets, those get pulled in too, so AI obtains the big picture rather than one isolated ticket with missing context.Tus archivos .sql se pueden ejecutar directamente en cualquier cliente de base de datos, independientemente de la propia herramienta
  • Handles screenshots and attachments. Files attached to a ticket often require a login to access, which normally blocks an AI from seeing them at all. HAI fetches those attachments with the right credentials and makes them available locally.No hay ataduras a un entorno de ejecución de lenguaje, framework u ORM específicos
  • Splits the work efficiently. Under the hood, HAI uses a set of specialized roles: one that researches a task, one that plans it, dedicated ones that write backend, frontend, and refactoring code, and others that review the result for security and correctness. Those roles work in parallel rather than one after another, which shortens the time from ticket to working code.Cada migración vive en tu sistema de control de versiones como cualquier otro archivo fuente
  • Reduces working on tickets to a single command. Once set up, a developer can hand HAI a Jira ticket number and it takes care of the rest: pulling the context, researching the codebase, drafting a plan, and, once approved, implementing the change.

Capacidades clave

Esto es una compensación deliberada en favor de la transparencia y la portabilidad.

  • Leaders standardizing how their team uses AI. Developers naturally gravitate toward different tools. HAI lets them keep their preference while making sure the underlying workflow, and the results it produces, stay consistent.. Gestiona desarrollo, staging y producción desde una única configuración de proyecto. Las migraciones se controlan por entorno para que siempre sepas qué se ha aplicado dónde.
  • Teams working off Jira and Confluence, where the ticket and the spec that explains it live in separate places an AI assistant can't reach on its own. HAI automatically closes this gap.Inyecta valores específicos del entorno directamente en tus archivos SQL en tiempo de ejecución. Útil para apuntar a diferentes esquemas, prefijos de tabla o insertar datos de prueba que varían según el entorno.
  • Engineering managers who are tired of “tribal” knowledge and looking to unify AI usage. To put it more simply, people who want every developer's assistant configured the same way instead of relying on whatever each person happened to set up for themselves.Las credenciales nunca tienen que residir en el código fuente. SMT soporta archivos .env y AWS Secrets Manager, o puedes pasarlas en tiempo de ejecución a través de argumentos de CLI.
  • Organizations that don't want another platform, database or dashboard, and would rather have tickets and specs as files they can read, review changes to, and commit like anything else in the repo. HAI doesn't introduce a new dashboard or database to manage. Además de las migraciones versionadas, puedes ejecutar scripts SQL ad hoc (rellenos de datos, operaciones de mantenimiento, correcciones puntuales) con el mismo sistema de reemplazo dinámico aplicado.

Integración CI/CD

SMT se distribuye tanto como aplicación de escritorio como una

1npm install -g @2amtech/hai
2hai init

A partir de ahí, las migraciones se pueden ejecutar como parte de cualquier pipeline de CI/CD compatible con Node.js: GitHub Actions, GitLab CI, Jenkins, o la herramienta que su equipo ya utilice. Sin solicitudes interactivas ni dependencia de GUI en entornos de automatización.hai init walks the team through choosing an AI provider and where tickets and specs should come from. It also runs the first sync automatically, so there's no separate setup step before the tool is usable. Based on their preferences, teams can choose to:

  • Point HAI at Jira and Confluence
  • at local files if they prefer to keep documentation in the repository,
  • or skip ticket integration entirely and use HAI just for its shared workflow and roles.

Free, Open Source, Apache 2.0 Licensed

Tanto la aplicación de escritorio (disponible para

In other words, all data stays yours and is kept locally; nothing is sent to the server. There’s no new system to manage. 

If your team is already spread between different AI coding editors, or if context keeps getting lost between the ticket, the Confluence spec, and the AI doing the work, HAI is more than worth setting up.

Navigate

Empecemos

Si tu equipo está aplicando cambios de esquema manualmente, registrándolos en un documento compartido, o confiando en herramientas de migración ORM que abstraen demasiado, SMT merece la pena echarle un vistazo.2am.tech.