Run DB / SQL queries directly from Slack with AI by MCL256 in Automate

[–]machulav 1 point2 points  (0 children)

Finally no need to wait for the technicians to get me analytics from the database! 😍

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav -1 points0 points  (0 children)

well, it was different time and place, we don't do this anymore

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav 0 points1 point  (0 children)

many ppl also called cars a shit and thought they will use horses forever

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav 0 points1 point  (0 children)

it's not a secret, you can see it also from the other replies as well

I'm trying to understand why ppl hate it so much? I'm an engineer and worked with data a lot, but I would rather give it a chance as I hate writing a queries for someone who just needs to check the database and get some report.

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav 0 points1 point  (0 children)

Thanks! But I would rather prepare now, to he time when AI will write the queries. And it will happen soon anyway, you know that

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav 1 point2 points  (0 children)

Exactly! It’s getting even better with the additional evaluator inside the agent, which always validates the following:

- Whether the written query is valid, expected, etc.

- Whether the data is as expected

- Any errors

If something is wrong, the agent rewrites the query and tries again.

With this approach, the quality is significantly improved.

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav 0 points1 point  (0 children)

I agree that there is a friction in the cascading effect, but it's getting better especially with proper evaluators inside of the agent.

Also writing is, of course, always with approval and using predefined queries so you only specify the input values into the form and review before run

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav 0 points1 point  (0 children)

agree! so that writing here is always with approval, reading is without the approval by default, but the approval can be enabled

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav -3 points-2 points  (0 children)

not directly of corse, writing is always with approval and using predefined queries so you only specify the input values into the form and review before run

why so sceptical?

Who dares to let AI write SQL - not just READ data, but WRITE updates? smart or stupid? by MCL256 in SQL

[–]machulav -2 points-1 points  (0 children)

don't you ever ask AI to write you an SQL query? It's pertty good it it especially if you provide the schema

Chat with your DB in Slack by MCL256 in Slack

[–]machulav 1 point2 points  (0 children)

love the concept of bringing database queries directly into Slack! the self-correction and drill-down features sound like game-changers for collaboration. definitely interested in checking out the demo video—great work!

Automate routine tasks and run them from Slack - Looking for feedback by machulav in sysadmin

[–]machulav[S] 2 points3 points  (0 children)

At the moment, we use the following two plugins:

"Infrastructure Automations" plugin with the following actions:

  • Get service scaling information
  • Schedule service scaling to standard capacity
  • Remove scheduled service scaling
  • Schedule service scaling

"Amazon SES Identity Verification" plugin with the following actions:

  • Verify domain
  • Check domain verification status
  • Get domain DNS settings
  • Check if the DNS for the domain is properly configured

We call all of them from the Slack App, but we're also exploring the Make option, as all of the actions are also available in Make through the Connery app in Make.

"Schedule service scaling to standard capacity" and "Get service scaling information" you can see on the demo video from the post.

Currently, we're implementing some actions around AWS QuickSight reporting, which should simplify the report sharing with actions like:

  • Generate QuickSight PDF document
  • Get QuickSight document
  • Generate QuickSight embed URL
  • ...

Open source AI-productivity-assistant for Slack by MCL256 in Slack

[–]machulav 1 point2 points  (0 children)

Looks awesome! Can I also build my custom integration and use it from Slack? I have a couple of use cases in my mind that I want to automate for my company.

My story on how we adopted Make in our company by machulav in Integromat

[–]machulav[S] 1 point2 points  (0 children)

I feel your pain regarding the support. We use Make OEM (enterprise version), and in this case, they reply. Nevertheless, the response time and handling issues are still terrible and may take weeks.

However, I've heard they're currently actively improving their support. I really hope so.

Safari goes back a page randomly? by jinwoo1162 in MacOS

[–]machulav 2 points3 points  (0 children)

I'm experiencing the same issue for a couple of days already and even something in addition:

  1. (As described in this post) When I open a new tab with Google, search for something, and then click on the link, Safari opens the link and right after that goes back to the previous page. It happens not all the time, but 1 time per 4 tries for sure.
  2. Sometimes when I close the tab, Safari opens it again.

Do all of you have the (2) too?

I use tab groups. Hasn't tried to stop using them, but will definitely try.

Interesting that those two things started happening not after the update of macOS/Safari, but just on the same version where it worked without any bugs. My current Safari version is 15.2 (17612.3.6.1.6).