[syastrov]

I’d like a tool that automatically suggests which indexes to add/remove, including use of different types of indexes and partial indexes, based on the queries being performed. Even better if it can automatically test the results of that on a production workload.

Or suggest schema changes that would improve normalization or performance.

[zihotki]

RavenDB (1) got you covered but it's a document database. It automatically creates indexes and has a lot of built-in features to improve operability.

1 - https://ravendb.net/features#indexes

[BrentOzar]

> I’d like a tool that automatically suggests which indexes to add/remove, including use of different types of indexes and partial indexes, based on the queries being performed

The data to do this is built into Microsoft SQL Server, and the open source sp_BlitzIndex does exactly what you're asking for.

[kristiandupont]

I wrote a "linter" for database (postgres) schemas. It doesn't currently say anything about indices but I am looking into that because that seems like something that you could make qualified guesses about.

[link redacted]

[RussianCow]

If you're using Postgres, check out dexter[0].

[0]: https://github.com/ankane/dexter

[thrower123]

The Azure SQL database services are pretty nifty in this regard.