What is our primary use case?
I use Supabase Vector to build semantic search functionality for all the client websites that we handle, and it allows us to search by meaning rather than the exact keyword. As a team, we mainly use it for semantic search functionality, and our clients find it helpful too.
One of my clients had an e-commerce website for a fashion store, and customers were always frustrated because the traditional keyword search did not work really well. For example, if a user searched for summer clothes for the beach, they only got products that had exact keywords, but searching for light clothing for vacation would show completely different results. Many customers were frustrated about this problem and handed it over to us. We built a semantic search feature using Supabase Vector. I stored embeddings by creating vector embeddings for all 500 products using OpenAI's embedding API. Each product had the title, description, category, and tags, which we converted to vector format and stored in Supabase Vector. When a user types a query, the query is converted into a vector, and Supabase Vector finds the most similar products using similarity search and returns the results ranked by relevance. Previously, 50% of searches returned no results or irrelevant products, but we changed that to 90% of searches returning relevant results. This was a very significant improvement that our client did not expect from us, and it was only possible because we implemented that semantic search functionality on the website. Supabase Vector understood that walking shoes and hiking boots are related even though they are different words, and customers could now find whatever they needed in a more natural way, searching with natural language and getting the things they need. It was a great leap for that website, and it worked really well.
I have another project that I worked on where I worked with a client who had a large content management system with over 10,000 blog posts and articles. They wanted me to build an AI-powered chatbot that could answer user questions based on their content. I built a RAG and created vector embeddings for all 10,000 articles and stored them in Supabase Vector. When the user asks a question such as how to optimize a website for SEO, the query is converted to a vector and Supabase Vector finds the most relevant articles, mostly the top five. An AI model like an LLM reads those articles and generates a helpful answer that is sent back to the user. The answer accuracy was about 85%, and the users were satisfied. It saved a lot of the client's time, and the client specifically mentioned to me that they saved about $2,000 per month on support staff hours. This was a significant win for our agency, and all we did was store all the vector embeddings efficiently, and the similarity search was faster, scaling really well. The integration with other Supabase Vector features like authentication and a database made the whole system easier to build. Both projects were great successes, and Supabase Vector has been essentially the root cause for these successes.
We supported a small tech company with a knowledge base of over 5,000 support articles where users needed to search for help articles relevant to their queries, filtering for articles from the last six months and from specific product categories such as mobile app or desktop app. This posed a major challenge for us. Without hybrid search, if a user searched for help on resetting a password in the mobile app, they would see all relevant articles across the entire database, potentially including outdated articles. We implemented a hybrid approach using SQL and semantic search. We wrote a query for the semantic search to find similar articles for resetting passwords in the mobile app while the SQL filters ensured that we only returned articles from the mobile app category created in the last six months. This approach successfully retrieved five relevant articles with an accuracy of almost 95%. Users found it very useful and received the right answers. Narrowing down specific details was only possible with this hybrid search.
What is most valuable?
Based on my experience with Supabase Vector, I personally feel that Unified Data Storage, where we store vector embeddings right next to our relational data in PostgreSQL, is one of the top features I appreciate. Additionally, there is another feature in Supabase Vector, which is SQL and Vector Hybrid Search, allowing us to combine traditional SQL queries with semantic search effortlessly. This is absolutely amazing because it lets us filter by metadata while doing similarity search. Another feature that stands out is the fast similarity search with multiple index types. Supabase Vector supports IVFFlat and HNSW indexes for fast approximate nearby neighbor search, giving us, as an agency, the ability to reduce response time to under 100 milliseconds, even with over 25,000 articles, which is a killer feature. The built-in authentication and security, with all the RLS policies applied automatically to vector queries, gives us trust with all the clients we work with. Supabase Vector's seamless integration with all AI tools, such as OpenAI, Hugging Face, LangChain, and Amazon SageMaker, is a significant edge for us. The free tier of 500 MB database with vector support included is a real help that Supabase Vector provides us. Additionally, we appreciate the auto-generated REST API, as we do not need to build any custom API for vector queries, making our development much faster. These are the features that are currently on my mind.
Supabase Vector has had a significant positive impact on the agency I work for by increasing client delivery. We built semantic search and AI chatbot features for over eight client projects in the past year, and these features are now standard offerings I provide to new clients as well. Revenue has increased by about 20% to 30% in value, and we reduced development time for semantic search projects from seven to ten days down to just two to three days because the auto-generated API and unified storage save us a lot of hours on back-end work. I saved over 20 hours of development time for one client project using Supabase Vector, which is a significant gain. Additionally, we have greatly improved client results, such as a 30% increase in search-to-purchase conversions for the e-commerce client I mentioned, which was a big win. There was also a 40% reduction in customer support questions after building the AI chatbot for the content management client I discussed, allowing the client to save about $1,500 to $2,000 per month on support staff. We have seen substantial improvements in search accuracy and scaled from handling over 10,000 articles to more than 25,000 articles, making scalability another significant win. These are all the impacts that we have experienced in the organization, thanks to Supabase Vector.
What needs improvement?
Adapting to Supabase Vector was relatively smooth, but there was definitely a moderate learning curve at the start. The SQL foundation, REST API, documentation, and integration with all the AI tools made it easier. However, understanding embeddings, index types, similarity metrics, and how SQL and vector hybrid queries work, as well as the RLS policies for vectors, required some time to learn.
I do not have many things to point out, but a couple of areas for improvement come to mind. For index optimization guidance, clearer instructions on when to use IVFFlat versus HNSW indexes would be helpful. Additionally, having a built-in embedding generation capability would simplify the workflow, as currently, I use external services such as OpenAI or Hugging Face for that purpose.
For how long have I used the solution?
I have been using Supabase Vector for about one and a half years now.
What do I think about the stability of the solution?
Supabase Vector is absolutely stable for all the use cases I have delivered thus far.
What do I think about the scalability of the solution?
Supabase Vector is highly scalable for small to medium to large scale applications. The free tier itself supports about 1 to 2 million vectors, and I am storing over 1.6 million embeddings across eight client projects with varying performance levels in the free tier. I believe if I move to the Pro plan, it will offer even higher storage and compute capability. I find Supabase Vector's scalability absolutely amazing and it scales exceptionally well for various application sizes.
How are customer service and support?
The customer support has been excellent for my use as a new agency owner. Community support from helpful developers and engineers provides fast responses on GitHub issues and community forums. I have not encountered significant issues with customer support. I would rate the customer support a 9 out of 10.
Which solution did I use previously and why did I switch?
I did use a couple of other solutions before Supabase Vector, including manual data extraction with spreadsheets and separate data pulls from various APIs. I used Pinecone for one project and MongoDB with Atlas search for another. I switched to Supabase Vector because the manual processes were time-consuming, lacked real vector search capabilities, and the accuracy of results was poor. Transitioning to Supabase Vector enhanced search accuracy while providing unified storage without sync issues, proving to be more cost-efficient.
What was our ROI?
I have definitely seen a significant return on investment from Supabase Vector, saving about $1,000 to $1,500 per client project. Across eight client projects, I saved approximately $4,000 to $8,000 a month, and for the AI chatbot, I saved $2,000 by eliminating support staff hours. Development time has drastically reduced, as the automatically generated REST APIs minimize the major development work. Instead of handling projects from seven to ten days, we now complete them in just two to three days. For the eight projects I have managed, we save about 160 to 240 total hours. There has also been a 30% increase in search-to-purchase conversions for our clients, along with 90% to 95% accuracy with the similarity search. Overall, development has accelerated, and the client value we deliver improves, leading to increased profits for our organization.
What's my experience with pricing, setup cost, and licensing?
My experience with pricing, setup costs, and licensing has been very positive and cost-effective, as I utilize the free tier, which includes a 500 MB database with vector support at no cost, allowing support for millions of embeddings. This greatly benefits agencies like us, as it is free forever and does not require payment for a separate vector database service, covering most of my client projects without incurring costs. We have recently switched to a paid plan, the Pro plan for $25 a month that provides more storage, compute, and features. The zero setup cost and lack of upfront infrastructure costs, technical setup, and database configuration are important features that help us scale our services at a lower cost, making my experience with pricing and setup costs extremely positive.
Which other solutions did I evaluate?
I did evaluate other options such as Pinecone, Weaviate, and Qdrant before deciding on Supabase Vector. I ultimately switched because of the comprehensive features it offers.
What other advice do I have?
I would rate Supabase Vector an 8.5 overall. I would round that to a 9 because all the strongest features such as unified storage, hybrid search, and fast similarity search that we usually use are killer features. Supabase Vector saves a lot of development time for our agency and is essential in terms of semantic search and RAG systems, which gives me about six points. The remaining three points come from the free tier supporting millions of embeddings at no cost, which is a significant benefit for all agencies. I decrease one point due to minor documentation gaps for advanced features and the absence of built-in embedding generation, leading me to choose a score of nine. My overall review rating for Supabase Vector is 9 out of 10.
My advice to others looking to use Supabase Vector is to start with a project, build things, and get to know the features within Supabase Vector, especially exploring semantic search. This approach provides ample opportunity to understand how Supabase Vector works while working with substantial amounts of data. Therefore, I encourage everyone to begin with a small project, manage a use case, and once it delivers returns, consider transitioning to the Pro plan if necessary. It is advisable to switch from Pinecone or MongoDB Atlas search to Supabase Vector for an extensive hands-on experience that significantly reduces development time.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google