8000 feat: add AI agents database schema and migration by notgiorgi · Pull Request #14862 · lightdash/lightdash · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

feat: add AI agents database schema and migration #14862

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Merged
merged 3 commits into from
May 21, 2025
Merged

feat: add AI agents database schema and migration #14862

merged 3 commits into from
May 21, 2025

Conversation

notgiorgi
Copy link
Contributor
@notgiorgi notgiorgi commented May 16, 2025 •
edited
Loading

Closes: #14847

Description:

Add database schema for AI Agents, migrate old slack-first schema

  • Creates ai_agent table to store agent configurations with name, description, and data sources
  • Creates ai_agent_integration table to manage integrations (currently supporting Slack)
  • Adds agent_uuid column to the existing ai_thread table
  • Includes a migration to convert existing Slack channel mappings to the new agent structure
  • Migrations are revertable and do not delete any data
  • All the existing features work as expected

Before:
mermaid_before.png

After:

updated_diagram.png

@notgiorgi Graphite App
Copy link
Contributor Author
notgiorgi commented May 16, 2025 •
edited
Loading

This stack of pull requests is managed by Graphite. Learn more about stacking.

@notgiorgi notgiorgi mentioned this pull request May 16, 2025
Merged
@notgiorgi notgiorgi marked this pull request as ready for review May 16, 2025 17:32
graphite-app[bot]
graphite-app bot reviewed May 16, 2025
View reviewed changes
joaoviana
joaoviana reviewed May 19, 2025
View reviewed changes
Copy link
Contributor
@joaoviana joaoviana left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

looking great, some thoughts 🙏

@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from 495a45e to 87903d0 Compare May 19, 2025 17:18
@notgiorgi notgiorgi force-pushed the 05-16-feat_agent_configuration_api_spec branch from de806db to f0e0730 Compare May 19, 2025 17:18
@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from 87903d0 to 9d36862 Compare May 19, 2025 17:25
@notgiorgi notgiorgi force-pushed the 05-16-feat_agent_configuration_api_spec branch from f0e0730 to 05ceafb Compare May 19, 2025 17:25
@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from 9d36862 to d30c666 Compare May 20, 2025 08:48
@notgiorgi notgiorgi force-pushed the 05-16-feat_agent_configuration_api_spec branch from 05ceafb to 636203a Compare May 20, 2025 09:01
@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from d30c666 to 5419b5f Compare May 20, 2025 09:01
Base automatically changed from 05-16-feat_agent_configuration_api_spec to main May 20, 2025 09:21
@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from 5419b5f to 521e765 Compare May 20, 2025 10:07
@owlas owlas requested a deployment to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - jaffle_db_pg_13 PR #14862 May 20, 2025 10:07 — with Render Abandoned
@owlas owlas deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - headless-browser PR #14862 May 20, 2025 10:07 — with Render Active
@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from 521e765 to b702489 Compare May 20, 2025 15:27
@render render bot requested a deployment to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - jaffle_db_pg_13 PR #14862 May 21, 2025 11:19 Abandoned
@owlas owlas temporarily deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - lightdash PR #14862 May 21, 2025 11:20 — with Render Destroyed
@notgiorgi notgiorgi force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from 7eacad3 to b169683 Compare May 21, 2025 11:21
@owlas owlas temporarily deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - lightdash PR #14862 May 21, 2025 11:21 — with Render Destroyed
@owlas owlas deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - headless-browser PR #14862 May 21, 2025 11:21 — with Render Active
@owlas owlas deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - headless-browser PR #14862 May 21, 2025 11:31 — with Render Active
@notgiorgi notgiorgi requested review from joaoviana and removed request for tatianainama and joaoviana May 21, 2025 11:33
@IrakliJani IrakliJani force-pushed the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch from ea5e746 to 15e5420 Compare May 21, 2025 12:31
@owlas owlas temporarily deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - lightdash PR #14862 May 21, 2025 12:31 — with Render Destroyed
@owlas owlas temporarily deployed to 05-16-feat_migrate_ai_data_model_to_incorporate_agents - headless-browser PR #14862 May 21, 2025 12:31 — with Render Destroyed
@IrakliJani IrakliJani mentioned this pull request May 21, 2025
Merged
3 tasks
@notgiorgi notgiorgi merged commit 8441370 into main May 21, 2025
34 of 37 checks passed
@notgiorgi notgiorgi deleted the 05-16-feat_migrate_ai_data_model_to_incorporate_agents branch May 21, 2025 12:40
lightdash-bot pushed a commit that referenced this pull request May 21, 2025
@semantic-release-bot
chore(release): 0.1639.0
ca5e629 
# [0.1639.0](0.1638.4...0.1639.0) (2025-05-21)

### Features

* add AI agents database schema and migration ([#14862](#14862)) ([8441370](8441370))
@lightdash-bot
Copy link
Collaborator

🎉 This PR is included in version 0.1639.0 🎉

The release is available on:

Your semantic-release bot 📦🚀

This was referenced May 21, 2025
Merged
Merged
@notgiorgi notgiorgi mentioned this pull request May 21, 2025
Merged
@joaoviana joaoviana mentioned this pull request May 21, 2025
Merged
3 tasks
@notgiorgi notgiorgi mentioned this pull request May 21, 2025
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@joaoviana joaoviana joaoviana left review comments

@graphite-app graphite-app[bot] graphite-app[bot] left review comments

@IrakliJani IrakliJani IrakliJani approved these changes

Assignees

@notgiorgi notgiorgi

Labels
released
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Move from Slack-first data model to Agent-first data model
5 participants
@notgiorgi @lightdash-bot @IrakliJani @joaoviana @owlas
0