# mysql-vector Projects at AI Tinkerers

> Canonical HTML: https://aitinkerers.org/technologies/mysql-vector
> Markdown URL: https://aitinkerers.org/technologies/mysql-vector.md
> Technology record last updated: 2026-02-25T08:40:41Z
> Generated: 2026-09-22T07:49:59Z

MySQL-Vector integrates native vector data storage (VECTOR type) and similarity search functions into the MySQL 9.3+ relational database engine.

This technology is the native `VECTOR` data type and associated functions introduced in MySQL 9.3. It allows developers to store high-dimensional numerical embeddings directly in a relational table, eliminating the need for a separate vector database. The `VECTOR(N)` type stores up to 16,383 single-precision (4-byte) floating-point values. Key functions like `DISTANCE()` enable efficient similarity search (e.g., COSINE, DOT, EUCLIDEAN metrics), directly supporting GenAI applications like Retrieval-Augmented Generation (RAG) and semantic search within the familiar MySQL ecosystem.

- Official technology site: https://dev.mysql.com/doc/refman/9.3/en/vector.html
- Public AI Tinkerers demos and talks: 1
- Result page: 1 of 1

## Recent Public Talks and Demos

### [Live AI chatbots and Vector Search with Laravel, Vue.js, and MySQL](https://boston.aitinkerers.org/talks/rsvp_ds3pqfXmJvM)

The primacy of python and dedicated vector databases for search might be due to the hype driven by enterprise solutions. But there are thousands of PHP and MySQL websites out there that could benefit from Vector Search. With an implementation of this modified from one created by Allan Pichardo ( pichardo.dev ) called mysql-vector this demonstrates the feasibility of native vector search with MySQL and PHP.

- Event context: AI Tinkerers September Meetup Sponsored by BasisTech — 2024-09-23 — Boston
- Public talk page: https://boston.aitinkerers.org/talks/rsvp_ds3pqfXmJvM

## Related Technologies

- [Laravel](https://aitinkerers.org/technologies/laravel) ([Markdown](https://aitinkerers.org/technologies/laravel.md)) — 4 public demos
- [MySQL](https://aitinkerers.org/technologies/mysql) ([Markdown](https://aitinkerers.org/technologies/mysql.md)) — 7 public demos
- [PHP](https://aitinkerers.org/technologies/php) ([Markdown](https://aitinkerers.org/technologies/php.md)) — 7 public demos
- [Vue](https://aitinkerers.org/technologies/vue) ([Markdown](https://aitinkerers.org/technologies/vue.md)) — 8 public demos