How to select LLM for SQL generation

Imagine a scenario where a data analyst needs to generate SQL queries to extract specific information from a complex data warehouse, but without deep knowledge of SQL. Our goal was to create an AI assistant that translates natural language to SQL, and we wanted to find the optimal large language model (LLM) for this task. We needed a solution that balances performance and cost while handling the limitations of context windows. A context window refers to the amount of text […]

Mariia Horova (Full stack developer), Oleksii Svitlychnyi (Technical writer)
AWS Confirms The High Quality of Our GenAI Solutions

At ABCloudz, we are committed to delivering quality and trustworthiness in every solution we create. Recently, two of our AI-powered solutions, Natural Language Interface for Data Platform and AI Text Classification and Matching, successfully passed the rigorous AWS Foundational Technical Review (FTR). This achievement validates our technical expertise and reinforces our commitment to delivering reliable, high-performance solutions that meet AWS’s exacting standards. What is the FTR and what it takes to pass? The AWS Foundational Technical Review is a comprehensive […]

Oleksii Svitlychnyi
Natural Language Interface for Data Platform

Imagine a business analyst whose task is to extract necessary information from a data warehouse to generate various reports. They need to be proficient in crafting SQL queries of any complexity—a challenging and time-consuming feat that requires deep understanding of database structures and SQL language. But what if this business analyst had an AI assistant to whom they could describe the required data and format in natural language? This assistant would understand the request and convert it into an SQL […]

Maksym Kurhanetskyi, Oleksii Svitlychnyi
AI Text Classification and Matching for Better Decisions

Picture this: You have an AI-powered assistant that helps manage your team’s growth. It works with three types of text data: job descriptions, employee skills, and training programs. You give it a job description and an employee’s skill set, and it pinpoints the perfect training programs to bridge any skill gaps. It’s like having a tailor-made career coach that ensures your team is always ready for their next big challenge.We have developed precisely this kind of solution — an AI-based […]

Maksym Kurhanetskyi, Oleksii Svitlychnyi
ABCloudz Achieves Microsoft’s Data & AI Solutions Partner Designation

Data is the lifeblood of any business. The ability to extract insight and value from data plays a critical role in determining long-term success. Efficient data utilization can drive streamlined business processes, reduce waste, and enable well-informed strategic decisions. With the advent of cloud-powered AI and analytics tools, organizations now have unprecedented access to transformative capabilities. That’s why ABCloudz is thrilled to announce its designation as a Microsoft Solutions Partner for Data & AI. This recognition underscores our expertise in […]

Adam Robertson
Calculate the Total Cost of a RAG-Based Solution

This blog post examines the operational expenses of the AI-powered chatbot solution introduced in our previous blog posts, Custom AI chatbot using RAG and Deployment of AI-Powered Chatbot. This solution operates on the AWS cloud while integrating OpenAI’s language model. We will discuss the financial aspects of infrastructure costs and analyze how to estimate expenses for AI resources, such as Language Model as a service. Cost Structure of a Custom AI Chatbot Solution Operating expenses for our AI chatbot solution […]

Oleksii Svitlychnyi
Deployment of AI-Powered Chatbot

This blog post focuses on the architecture and deployment of the AI-powered Chatbot solution that we described in our earlier blog post Custom AI Chatbot Development Using RAG. This solution is built for the AWS cloud but uses OpenAI as an LLM. We’ll dive deep into the CI/CD process and AWS deployment architecture of the backend application. AWS Deployment Architecture Our solution represents a rather typical configuration of a web project deployed to AWS. Click or tap on the picture […]

Kostiantyn Odynets, Oleksii Svitlychnyi
Custom AI Chatbot Development Using RAG

You have probably seen and heard about AI-powered chatbots that can converse with the user about website content, or some piece of knowledge related to a company. The world is full of buzz on all things AI, with chatbots driving the headlines. In this article, we’ll share our experience building a full-blown solution from scratch that empowers such chatbots. The goal is to build a framework that can be plugged in with any knowledge sources and be easily integrated into […]

Maksym Kurhanetskyi, Oleksii Svitlychnyi
Integrating AI into Bionic Hands

In previous blog posts, we provided a functional overview and delved into the technical details of Alt-Bionics’ affordable prosthetic hand, outlining the journey from concept to a product ready for commercial release. What does it take to train an AI to interpret the unique language of muscle signals? This chapter peels back the curtain on the AI training process, revealing how each prosthetic hand is fine-tuned to its wearer’s unique muscular patterns. Unlike the traditional approach, our AI doesn’t generalize; it […]

Dmitriy Liukevych, Oleksii Svitlychnyi
Best Open-Source Tools for AI Video Enhancement

In the ever-evolving landscape of digital content, achieving impeccable video quality has become more than just a desire; it’s a necessity. As you delve into the world of AI video enhancement, you might find yourself amidst a sea of options. Navigating this space, especially if you’re embarking on app development or seeking to elevate your existing content, can be daunting. Fear not. This blog aims to be your compass, guiding you through the intricacies of open-source video enhancement tools. Together, […]

Roman Babchenko
Real-Time Object Detection and Classification in Sports Using AI and Computer Vision

Imagine being able to quickly recognize the positions of players and referees, grouped by their respective teams, while watching a live soccer, popularly also known as football in various other parts of the world. This is no longer just a pipe dream, but rather a reality, thanks to developments in AI and computer vision technologies. With a particular emphasis on a soccer match as an example, we will dig into the intriguing world of real-time object recognition and classification using […]

Roman Babchenko
Building an Intelligent Chatbot with OpenAI LLM using RAG

Chatbots as they come are not something new under the sky. They have populated the web since long ago leaving behind an impressive trail of user annoyance and frustration. Wild repetitions, endless question-answer loops, and downright stupidity were the common laments to splash in jokes among the cubicle drones. The only improvements seemed to be expected from the further growth of output speed and size of Q&A database. The recent breakthroughs in Artificial Intelligence (AI) brought the benefits of this […]

Maksim Kurganetskiy
Keyword spotting on embedded device demo

In this article, I will share my experience setting up a software demo project for a device, which can recognize and act on certain voice commands. The solution will be used to evaluate the feasibility of using ML (Machine Learning) approach to detect keywords in a constrained environment. Our demo is quite simple conceptually: a hardware device with connected LEDs and a microphone. The microphone is listening to voice commands recognizing three main colors: GREEN, RED, and WHITE. For each […]

Dmytro Liukevych
Leveraging the power of ChatGPT with Keyssistant

OpenAI’s ChatGPT captured imagination of the world with unlimited possibilities it can bring to our daily life. Our mobile team had many ideas for the projects, and one of them revolved around creating a smart keyboard powered by AI. Introducing Keyssistant Keyssistant is a mobile keyboard extension that seamlessly integrates AI-powered capabilities into all messaging apps on your smartphone. The solution connects to ChatGPT via the OpenAI API. The extension offers a selection of AI-generated responses in various conversational styles, […]

Pavlo Pozdniakov
BLE Autoinjector Integration for Healthcare Solutions

Explore our project where we developed firmware with ML capabilities for a smart autoinjector and integrated it with our custom app, revolutionizing self-medication and comprehensive care. In collaboration with a leading pharmaceutical company, our team has developed a system that transcends traditional paper logs and manual reminders, fostering a more intuitive treatment experience. This initiative not only focuses on drug manufacturing but also on delivering complete care solutions, including smart packaging that tracks medication intake and supports remote monitoring for […]

Kirill Zakharenkov

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?

ABCAssist